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