Re: [BUGS] BUG #7501: Unique index fails to check uniqueness on nulls

2012-08-23 Thread Jeff Davis
On Thu, 2012-08-23 at 09:38 +, matthew.p.kusni...@jpmorgan.com wrote: > Multi-column unique indexes allow duplicate rows to be inserted if any of > the indexed columns are inserted with a null. That is mandated in the SQL spec, and is documented here: "For the purpose of a unique constraint,

[BUGS] BUG #7501: Unique index fails to check uniqueness on nulls

2012-08-23 Thread matthew . p . kusnierz
The following bug has been logged on the website: Bug reference: 7501 Logged by: Matt Kusnierz Email address: matthew.p.kusni...@jpmorgan.com PostgreSQL version: 9.0.4 Operating system: Windows XP Description: Multi-column unique indexes allow duplicate rows to be ins