[GENERAL] trouble with unique constraint

2010-02-11 Thread Khin, Gerald
The following SQL leads to a unique constraint violation error message (PostgreSQL 8.4.1). create table test (val integer); create unique index test_uni on test(val); insert into test (val) values (1); insert into test (val) values (2); insert into test (val) values (3); update

[GENERAL] trouble with unique constraint

2010-02-11 Thread Khin, Gerald
The following SQL leads to a unique constraint violation error message (PostgreSQL 8.4.1). create table test (val integer); create unique index test_uni on test(val); insert into test (val) values (1); insert into test (val) values (2); insert into test (val) values (3); update