array exclusion constraints

Поиск
Список
Период
Сортировка
От francisk@hush.com
Тема array exclusion constraints
Дата
Msg-id 20141113183843.E8AC620362@smtp.hushmail.com
обсуждение исходный текст
Ответы Re: array exclusion constraints  (Antonin Houska <ah@cybertec.at>)
Список pgsql-hackers
CREATE TABLE test (  foo text[],  EXCLUDE USING gist (foo WITH &&)
);

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.

It looks like exclusion constraints don't work with arrays, there's no gist opclass for them. This would be a nice to
havefeature and, if I recall correctly, exclusion constraints were meant to work both with ranges and arrays. Am I
missingsomething?
 

Regards,
Francis




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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: controlling psql's use of the pager a bit more
Следующее
От: Robert Haas
Дата:
Сообщение: Re: group locking: incomplete patch, just for discussion