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

# Jayadevan.Maymala@ibsplc.com / 2010-01-04 10:03:29 +0530:
> From:   neuhauser+pgsql-general#postgresql.org@sigpipe.cz
> >
> > 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?
>
> Hi,
> This seems to work..
> UPDATE x  set i=i+1
> from  (select i as m from x order by m desc) y   where x.i = y.m
> Jayadevan

Thanks, that nicely achieves the illusion of atomic immediate checking.

--
Roman Neuhauser