Skip site navigation (1) Skip section navigation (2)

RE: Update is not atomic

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'vitus(at)ice(dot)ru'" <vitus(at)ice(dot)ru>, pgsql-bugs(at)postgresql(dot)org
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Update is not atomic
Date: 2001-06-20 16:43:05
Message-ID: 3705826352029646A3E91C53F7189E32016681@sectorbase2.sectorbase.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

Responses

pgsql-hackers by date

Next:From: Mikheev, VadimDate: 2001-06-20 16:50:46
Subject: RE: [BUGS] Update is not atomic
Previous:From: Ross J. ReedstromDate: 2001-06-20 15:40:07
Subject: Re: RE: Universal admin frontend

pgsql-bugs by date

Next:From: Jan WieckDate: 2001-06-20 21:27:20
Subject: Re: [HACKERS] RE: Update is not atomic
Previous:From: Victor WagnerDate: 2001-06-20 16:02:06
Subject: Re: Update is not atomic

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group