Re: Update is not atomic

Victor Wagner writes:

> create table a (a numeric primary key);
> insert into a values (1);
> insert into a values (2);
> insert into a values (3);
> insert into a values (4);
> update a set a=a+1 where a>2;
> ERROR:  Cannot insert a duplicate key into unique index a_pkey

This is a known problem with unique contraints, but it's not easy to fix
it.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter