Обсуждение: Compiling with GIST

Поиск

Список

Период

Сортировка

Compiling with GIST

От

George Smith

Дата:

26 октября 2006 г., 13:57:35

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

Re: Compiling with GIST

От

Teodor Sigaev

Дата:

26 октября 2006 г., 14:41:08

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Compiling with GIST

Compiling with GIST

Re: Compiling with GIST