RE: [BUGS] Update is not atomic

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>, Victor Wagner <vitus(at)ice(dot)ru>
Cc: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: [BUGS] Update is not atomic
Date: 2001-06-20 16:50:46
Message-ID: 3705826352029646A3E91C53F7189E32016682@sectorbase2.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-06-20 17:21:14 AW: Re: Re: REPLACE INTO table a la mySQL
Previous Message Mikheev, Vadim 2001-06-20 16:43:05 RE: Update is not atomic