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-11 13:41:16
Message-ID: BD02AF110737DE438CE0C85251D7DF5C461E8D@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 Ben Campbell 2010-02-11 13:44:51 Re: problems maintaining boolean columns in a large table
Previous Message Davor J. 2010-02-11 13:40:12 Function that creates a custom table AND returns it = impossible in pg?