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
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