Ken Guest <kguest(at)stockbyte(dot)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