Skip site navigation (1) Skip section navigation (2)

Re: Compiling with GIST

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: George Smith <georgesmithblack(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Compiling with GIST
Date: 2006-10-26 17:39:02
Message-ID: 4540F2B6.9090202@sigaev.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
> HINT:  You must specify an operator class for the index or define a 
> default operator class for the data type.
> ERROR:  data type character varying has no default operator class for 
> access method "gist"

use contrib/btree_gist module: compile it and add to your database by command 
'psql DB < btree_gist.sql'.
-- 
Teodor Sigaev                                   E-mail: teodor(at)sigaev(dot)ru
                                                    WWW: http://www.sigaev.ru/

In response to

pgsql-hackers by date

Next:From: Neil ConwayDate: 2006-10-26 17:47:24
Subject: GUC description cleanup
Previous:From: Andrew DunstanDate: 2006-10-26 17:37:01
Subject: plperl/plperlu interaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group