trouble with unique constraint

From: "Khin, Gerald" <Gerald(dot)Khin(at)ids-scheer(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: trouble with unique constraint
Date: 2010-02-08 13:36:39
Message-ID: BD02AF110737DE438CE0C85251D7DF5C461A6A@49FR-MEEVS1.me.corp.ids-scheer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2010-02-08 13:40:42 Re:
Previous Message Farrer, Rhys 2010-02-08 13:32:46 Fwd: [pgadmin-support] a quick question