From: | Carsten Kropf <ckropf2(at)fh-hof(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | User defined type - analyze problem |
Date: | 2010-05-03 06:10:53 |
Message-ID: | 06AAECF5-794B-4BC4-8BE0-A4D2E937B092@fh-hof.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi *,
I have a little problem with a user defined type:
I constructed a type called "pointnd" which represents a multi-dimensional point. This point is subsequently used as an array type in another user defined type, like the following:
CREATE TYPE document AS (words tsvector, points _pointnd);
After some time, I have some problems with this type, obviously. The postgres process keeps on reporting the following line:
ERROR: could not identify a comparison function for type pointnd
CONTEXT: automatic analyze of table "test.public.documents"
I read somewhere, that this can be solved by preparing a operator class for btree and passing a comparison function for equality there. I did this with the following lines:
CREATE OPERATOR CLASS pointnd_btree_class
DEFAULT FOR TYPE pointnd USING btree AS
OPERATOR 3 =(pointnd, pointnd)
;
However, the postges process still reports the same errors after having set up the btree operator class.
How can I solve this issue?
Best regards
Carsten Kropf
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Lopes | 2010-05-03 08:44:28 | Dynamic SQL with pgsql, how to? |
Previous Message | Scott Marlowe | 2010-05-03 06:08:01 | Re: PostgreSQL vs. Microsoft SQL server |