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

From: "Gregory Maxwell" <gmaxwell(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: GIST and GIN indexes on varchar[] aren't working in CVS.
Date: 2007-09-02 05:29:20
Message-ID: e692861c0709012229n2c871d4cjfeafc51696881e1a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-09-02 09:50:56 Re: [PATCH] Lazy xid assingment V2
Previous Message Tom Lane 2007-09-02 03:27:21 Re: [PATCH] Lazy xid assingment V2