Postgres Pro
Downloads
Home   >   mailing lists

Thread: RE: [BUGS] Update is not atomic

RE: [BUGS] Update is not atomic

From
"Mikheev, Vadim"
Date:
> > 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