# da...@fetter.org / 2009-12-31 08:04:58 -0800: > On Thu, Dec 31, 2009 at 10:52:20AM +0100, > neuhauser+pgsql-general#postgresql....@sigpipe.cz wrote: > > 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? > > This will work in 8.5: > > CREATE TABLE x ( > i int NOT NULL UNIQUE DEFERRABLE INITIALLY DEFERRED > ); > INSERT INTO x (i) VALUES (1), (2), (3); > UPDATE x SET i = i + 1;
thanks, this might be a bearable workaround in some cases provided there's also SET CONSTRAINTS ... DEFERRED / IMMEDIATE. what I really want is a mode that fires the constraint check at the end of the statement. -- Roman Neuhauser -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
