set-level update fails with unique constraint violation - Mailing list pgsql-general

From neuhauser+pgsql-general#postgresql.org@sigpipe.cz
Subject set-level update fails with unique constraint violation
Date
Msg-id 20091231095220.GA1484@isis.sigpipe.cz
Whole thread Raw
Responses Re: set-level update fails with unique constraint violation
Re: set-level update fails with unique constraint violation
Re: set-level update fails with unique constraint violation
List 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

pgsql-general by date:

Previous
From: Dmitry Koterov
Date:
Subject: Re: Visual DATA editor for PostgreSQL?
Next
From: Magnus Hagander
Date:
Subject: Re: set-level update fails with unique constraint violation