Обсуждение: trouble with unique constraint
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 test set val = val + 1;
But it works fine with Oracle, MSSQL and DB2. Any idea how to make it working with PostgreSQL as well?
In response to 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 test set val = val + 1; update test set val = val + 10; update test set val = val -9; Thats the only way now, but the upcoming new release 9.0 contains deferrable unique constraints. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99