[DOCS] can't reproduce example

Поиск
Список
Период
Сортировка
От herve@duchesne.me
Тема [DOCS] can't reproduce example
Дата
Msg-id 20170922150333.1448.70668@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [DOCS] can't reproduce example  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.5/static/rangetypes.html
Description:

I tried to reproduce the example : 
CREATE EXTENSION btree_gist;
CREATE TABLE room_reservation (   room text,   during tsrange,   EXCLUDE USING GIST (room WITH =, during WITH
&&)
);

but I got this error :
ERROR:  data type text has no default operator class for access method
"gist"
HINT:  You must specify an operator class for the index or define a default
operator class for the data type.

That means by default nobody is able to reproduce your example... Howto use
gist with text or varchar?

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

В списке pgsql-docs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [DOCS] CREATE GROUP: REPLICATION, NOREPLICATION, BYPASSRLS,NOBYPASSRLS, CONNECTION LIMIT connlimit
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [DOCS] can't reproduce example