Re: [GENERAL] trouble with unique constraint

2010-02-11 Thread 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

[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

Re: [GENERAL] trouble with unique constraint

2010-02-11 Thread 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 tes

[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