Postgres Pro
Downloads
Home   >   mailing lists

Re: EXLCUDE constraints and Hash indexes - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: EXLCUDE constraints and Hash indexes
Date
Msg-id fb020e05-02c1-445f-8115-b8227ae9f9a3@BlueTreble.com
Whole thread Raw
In response to Re: EXLCUDE constraints and Hash indexes  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Tree view 
On 8/17/16 8:12 AM, Andrew Gierth wrote:
> I also recently found a case where using btree exclusion constraints was
> useful: a unique index on an expression can't be marked deferrable, but
> the equivalent exclusion constraint can be.

That seems well worth documenting...
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: PROPOSAL: make PostgreSQL sanitizers-friendly (and prevent information disclosure)
Next
From: Michael Paquier
Date:
Subject: Re: LSN as a recovery target