Dmitry Tkach <[EMAIL PROTECTED]> writes:
> I am trying to create a custom GiST index in 7.3, but getting an error,
> ...
> I have done all the setup that was required in 7.2.4:
You should not be using the 7.2 methods anymore --- there is a CREATE
OPERATOR CLASS, use that instead. (See the contrib gist classes for
examples.)
> testdb=# select * from pg_opclass where opcname = 'gist_index_ops';
> -[ RECORD 1 ]+--------------
> opcamid | 783
> opcname | gist_index_ops
> opcnamespace |
> opcowner |
> opcintype | 20
> opcdefault | t
> opckeytype | 0
Those NULL fields probably explain your problems ... (the fields are
marked NOT NULL, but due to an oversight, the constraint is not
enforced against core system catalogs in 7.3 :-()
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
