Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 31 Dec 2009 10:52:20 +0100
- Message-id: <20091231095220.GA1484@isis.sigpipe.cz> <text/plain>
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
- Follow-Ups:
- Re: set-level update fails with unique constraint violation
- From: David Fetter
- Re: set-level update fails with unique constraint violation
- From: Magnus Hagander
- Re: set-level update fails with unique constraint violation
- Prev by Date: Re: Visual DATA editor for PostgreSQL?
- Next by Date: Re: set-level update fails with unique constraint violation
- Previous by thread: conditional rule not applied
- Next by thread: Re: set-level update fails with unique constraint violation
- Indexes: