bug in "create unique index" - Mailing list pgsql-hackers

From Domingo Alvarez Duarte
Subject bug in "create unique index"
Date
Msg-id 3AFDB40F.AFC960BB@dad-it.com
Whole thread Raw
Responses Re: bug in "create unique index"  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
when creating a index unique in a table that accept nulls the unique
constraint doesn't work. 

Example:
---
create table test_unique(i1 integer, i2 integer, unique(i1,i2);
insert into test_unique(1,null);
insert into test_unique(1,null);
insert into test_unique(1,null);
---
all "inserts" above insert sucefully.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem with a rule on upgrade to v7.1.1
Next
From: Bruce Momjian
Date:
Subject: Re: 7.2 items