Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group