Postgres Pro
Downloads
Home   >   mailing lists

Re: creating index works OK on one db, not on other - Mailing list pgsql-general

From Tom Lane
Subject Re: creating index works OK on one db, not on other
Date
Msg-id 16609.1038522240@sss.pgh.pa.us
Whole thread Raw
In response to creating index works OK on one db, not on other  (Ken Guest <kguest@stockbyte.com>)
List pgsql-general
Tree view 
Ken Guest <kguest@stockbyte.com> writes:
> I have a problem with creating a specific type of index in postgres.
> Within the same system, it is created OK on one database but not on another.

> CREATE INDEX key2img_fr_rdtree_idx on image_fr using  gist ( key2img
> gist__intbig_ops) with ( islossy );

> works on one database but on the other one, I get this:
> ERROR:  DefineIndex: opclass "gist__intbig_ops" not found

Evidently you installed the contrib/intarray module into one database
but not the other.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: compiler error with 7.3
Next
From: Tom Lane
Date:
Subject: Re: Create Timestamp From Date and Time