Re: Exclusion Constraints on Arrays?

On Wed, May 23, 2012 at 1:34 PM, Peter Geoghegan <peter@2ndquadrant.com> wrote:
> On 13 May 2012 23:45, Robert Haas <robertmhaas@gmail.com> wrote:
>> Hmm, it looks like GIN can't support exclusive constraints because
>> amgettuple support is required, and unfortunately that got remove for
>> GIN in this commit:
>>
>> commit ff301d6e690bb5581502ea3d8591a1600fd87acc
>
> That seems very unfortunate, given that the 9.0 release notes say:
>
> "Exclusion constraints generalize uniqueness constraints by allowing
> arbitrary comparison operators, not just equality....This is useful
> for time periods and other ranges, as well as arrays."

I objected to it at the time, but lost the argument.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company