create unique index doesn't work properly

From: Domingo Alvarez Duarte <domingo(at)dad-it(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: create unique index doesn't work properly
Date: 2001-05-12 22:13:56
Message-ID: 3AFDB5A4.8E921F09@dad-it.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2001-05-13 00:19:05 Re: pg_config broken in 7.1.1 on FreeBSD with Tcl + Java
Previous Message Bruce Momjian 2001-05-12 21:11:17 Re: REQ: build src/backend/postgres w/o -lncurses or -lreadline