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

[Mikheev, Vadim]

> > 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.

Yes, it requires dirty reads.

Vadim

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]