Re: Update is not atomic

On Wed, 20 Jun 2001, Peter Eisentraut wrote:

> From: Peter Eisentraut <peter_e(at)gmx(dot)net>
> Subject: Re: [BUGS] 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.

Is there any known workaround?
Like specifying order of updates?

--
Victor Wagner vitus(at)ice(dot)ru
Chief Technical Officer Office:7-(095)-748-53-88
Communiware.Net Home: 7-(095)-135-46-61
http://www.communiware.net http://www.ice.ru/~vitus