From: | Antonin Houska <ah(at)cybertec(dot)at> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: array exclusion constraints |
Date: | 2014-11-13 21:03:40 |
Message-ID: | 9903.1415912620@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
francisk(at)hush(dot)com wrote:
>
> 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?
I recall I spent some time thinking about this issue, and even could find the
link (also referenced in "Indexes" section of
https://wiki.postgresql.org/wiki/TODO)
Regarding implementation, more recent thread summarizes the difficulties:
http://www.postgresql.org/message-id/5297DC17.7000608@proxel.se
--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2014-11-13 21:23:41 | Re: REINDEX CONCURRENTLY 2.0 |
Previous Message | Robert Haas | 2014-11-13 20:59:11 | alternative model for handling locking in parallel groups |