[HACKERS] Compiling with GIST

2006-10-26 Thread George Smith
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

Re: [HACKERS] Compiling with GIST

2006-10-26 Thread Teodor Sigaev
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