creating index works OK on one db, not on other

From: Ken Guest <kguest(at)stockbyte(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: creating index works OK on one db, not on other
Date: 2002-11-28 17:29:16
Message-ID: 3DE6526C.8040601@stockbyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

any ideas on what I need to do to get this working?

k.

________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message snpe 2002-11-28 17:43:47 Re: tuplestore : write failed
Previous Message Robert John Shepherd 2002-11-28 17:16:42 tsearch dictionaries and stop words