Re: [HACKERS] EXLCUDE constraints and Hash indexes

2016-08-19 Thread Jim Nasby
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

Re: [HACKERS] EXLCUDE constraints and Hash indexes

2016-08-17 Thread Andrew Gierth
> "Jeff" == Jeff Janes writes: Jeff> From: https://www.postgresql.org/docs/9.4/static/sql-createtable.html Jeff> "The access method must support amgettuple (see Chapter 55); at Jeff> present this means GIN cannot be used. Although it's allowed, there is Jeff>