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

Re: Updates not atomic with respect to indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Ben Young <ben(at)transversal(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Updates not atomic with respect to indexes
Date: 2004-04-28 12:37:51
Message-ID: 27402.1083155871@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> On Wed, 28 Apr 2004 09:33:34 +0100, Ben Young <ben(at)transversal(dot)com>
> wrote:
>> Is this [...] a known problem in Posgresql,
> Yes.
>> or bug which will be fixed sometime.
> Don't know.

I believe this is meant to be covered by this TODO item:

* Allow DEFERRABLE UNIQUE constraints

because the real issue is that the uniqueness check occurs immediately
rather than being deferred till end of statement or transaction.

Dunno when it will rise to the top of anyone's priority list...

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Ben YoungDate: 2004-04-28 12:53:24
Subject: Re: Updates not atomic with respect to indexes
Previous:From: Ian RibasDate: 2004-04-28 12:14:03
Subject: Re: Optimizer choosing smaller index instead of right one

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