GIST and GIN indexes on varchar[] aren't working in CVS. - Mailing list 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)