text type has no default operator class for GIN? - Mailing list pgsql-general

From Bob Gobeille
Subject text type has no default operator class for GIN?
Date
Msg-id 682FC3D7-A6B7-48E0-A549-0FF05A6E02C3@hp.com
Whole thread Raw
Responses Re: text type has no default operator class for GIN?  (Bob Gobeille <bob.gobeille@hp.com>)
List 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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: index "pg_authid_rolname_index" is not a btree
Next
From: John R Pierce
Date:
Subject: Re: Access Control System - Design