create unique index doesn't work properly - Mailing list pgsql-bugs

From Domingo Alvarez Duarte
Subject create unique index doesn't work properly
Date
Msg-id 3AFDB5A4.8E921F09@dad-it.com
Whole thread Raw
Responses Re: create unique index doesn't work properly  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
when executing the code bellow:

---
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" terminate sucefully, if there isn't "null" values it works
fine.

pgsql-bugs by date:

Previous
From: John Summerfield
Date:
Subject: Documentation problem in postgresql-7.0.2
Next
From: "A.V.Shutko"
Date:
Subject: Postgres bug (working with iserverd)