Re: creating index works OK on one db, not on other

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ken Guest <kguest(at)stockbyte(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: creating index works OK on one db, not on other
Date: 2002-11-28 22:24:00
Message-ID: 16609.1038522240@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-11-28 22:36:19 Re: Create Timestamp From Date and Time
Previous Message Tom Lane 2002-11-28 22:18:15 Re: compiler error with 7.3