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.
|
Список | 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 по дате отправления: