set-level update fails with unique constraint violation

From: neuhauser+pgsql-general#postgresql(dot)org(at)sigpipe(dot)cz
To: pgsql-general(at)postgresql(dot)org
Subject: set-level update fails with unique constraint violation
Date: 2009-12-31 09:52:20
Message-ID: 20091231095220.GA1484@isis.sigpipe.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

this fails with "duplicate key value":

CREATE TABLE x (
i INT NOT NULL UNIQUE
);
INSERT INTO x (i) VALUES (1), (2), (3);
UPDATE x SET i = i + 1;

are there any plans to make this work?

--
Roman Neuhauser

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-12-31 10:37:55 Re: pg_dump excluding tables content but not table schema
Previous Message Albe Laurenz 2009-12-31 08:26:59 Re: postgresql/postgis installation