Re: trouble with unique constraint

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