Re: [GENERAL] trouble with unique constraint

[A. Kretschmer]

In response to Khin, Gerald :
> The following SQL leads to a unique constraint violation error message

You have already got the answer ... for the same question from you.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] trouble with unique constraint

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

 

 

But it works fine with Oracle, MSSQL and DB2. Any idea how to make it
working with PostgreSQL as well?

 

 

Re: [GENERAL] trouble with unique constraint

[A. Kretschmer]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] trouble with unique constraint

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

 

 

But it works fine with Oracle, MSSQL and DB2. Any idea how to make it
working with PostgreSQL as well?