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)
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 |