text type has no default operator class for GIN?

From: Bob Gobeille <bob(dot)gobeille(at)hp(dot)com>
To: "pgsql-general(at)postgresql(dot)org List" <pgsql-general(at)postgresql(dot)org>
Subject: text type has no default operator class for GIN?
Date: 2009-08-18 21:46:42
Message-ID: 682FC3D7-A6B7-48E0-A549-0FF05A6E02C3@hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CREATE INDEX "ufile_name_search" ON "public"."uploadtree" USING GIN
("ufile_name");

ERROR: data type text has no default operator class for access method
"gin"
HINT: You must specify an operator class for the index or define a
default operator class for the data type.

This is on a new 8.3 install.
Why is this happening? Isn't creating a GIN index on a text type a
common thing to do?

I'm not seeing any mention of this in 8.3.7 docs cha 12 (Full Text
Search).

Do I really have to CREATE OPERATOR CLASS to make this work?
I see http://www.postgresql.org/docs/8.3/interactive/sql-createopclass.html

many thanks,
bob

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Gobeille 2009-08-18 21:50:47 Re: text type has no default operator class for GIN?
Previous Message John R Pierce 2009-08-18 21:45:59 Re: Access Control System - Design