Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-hackers by date:

Previous
From: "David D. Kilzer"
Date:
Subject: Re: [PATCHES] [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48]
Next
From: alavoor
Date:
Subject: PHP HOWTO v24.0 released: ADODB connects oracle, pgsql, mysql, sybase..