array exclusion constraints

From: francisk(at)hush(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: array exclusion constraints
Date: 2014-11-13 18:38:43
Message-ID: 20141113183843.E8AC620362@smtp.hushmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 have feature and, if I recall correctly, exclusion constraints were meant to work both with ranges and arrays. Am I missing something?

Regards,
Francis

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-11-13 19:26:41 Re: group locking: incomplete patch, just for discussion
Previous Message Merlin Moncure 2014-11-13 18:35:56 Re: controlling psql's use of the pager a bit more