GIST and GIN indexes on varchar[] aren't working in CVS.

Поиск
Список
Период
Сортировка
От Gregory Maxwell
Тема GIST and GIN indexes on varchar[] aren't working in CVS.
Дата
Msg-id e692861c0709012229n2c871d4cjfeafc51696881e1a@mail.gmail.com
обсуждение исходный текст
Ответы Re: GIST and GIN indexes on varchar[] aren't working in CVS.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
There seems to be some behavior change in current CVS with respect to
gist and gin indexes on varchar[]. Some side effect of the tsearch2
merge?


\d search_pages        Table "public.search_pages" Column   |        Type         | Modifiers
-----------+---------------------+-----------page_name | character varying   |cats      | character varying[] |
Indexes:   "search_pages_page" UNIQUE, btree (page_name)

create index search_pages_cats on search_pages using gin (cats);
ERROR:  missing support function 1 for attribute 1 of index "search_pages_cats"

create index search_pages_cats on search_pages using gist (cats);
ERROR:  data type character varying[] has no default operator class
for access method "gist"
HINT:  You must specify an operator class for the index or define a
default operator class for the data type.

This works fine in 8.2, for example:\d search_pages        Table "public.search_pages" Column   |        Type         |
Modifiers
-----------+---------------------+-----------page_name | character varying   |cats      | character varying[] |
Indexes:   "search_pages_page" UNIQUE, btree (page_name)   "search_pages_cats" gin (cats)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] Lazy xid assingment V2
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: [PATCH] Lazy xid assingment V2