Thread: Compiling with GIST
I have compiled postgres 1.8.5 on Windows XP from source using MinGW, however the GIST index cannot be created since the following errors pop up:
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"
Do I have to create them one by one?
Thanks
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"
Do I have to create them one by one?
Thanks
> 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@sigaev.ru WWW: http://www.sigaev.ru/