creating index works OK on one db, not on other

Поиск
Список
Период
Сортировка
От Ken Guest
Тема creating index works OK on one db, not on other
Дата
Msg-id 3DE6526C.8040601@stockbyte.com
обсуждение исходный текст
Ответы Re: creating index works OK on one db, not on other  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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
________________________________________________________________________

В списке pgsql-general по дате отправления:

Предыдущее
От: "Robert John Shepherd"
Дата:
Сообщение: tsearch dictionaries and stop words
Следующее
От: "Ron St.Pierre"
Дата:
Сообщение: Re: Create Timestamp From Date and Time