[HACKERS] RE: [BUGS] Update is not atomic

[Mikheev, Vadim]

> Problem can be demonstrated by following example
> 
> 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

We use uniq index for UK/PK but shouldn't. Jan?

Vadim

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster