| 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: | Whole Thread | Raw Message | 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
________________________________________________________________________
| 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 |