RE: [BUGS] Update is not atomic - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: [BUGS] Update is not atomic
Date
Msg-id 3705826352029646A3E91C53F7189E32016681@sectorbase2.sectorbase.com
Whole thread Raw
Responses Re: RE: [BUGS] Update is not atomic
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Jason Tishler
Date:
Subject: Re: [current] readline breakage
Next
From: Peter Eisentraut
Date:
Subject: Problem with reading startup packet after fork