Postgres Pro
Downloads
Home   >   mailing lists

Re: Updates not atomic with respect to indexes - Mailing list pgsql-general

From Manfred Koizar
Subject Re: Updates not atomic with respect to indexes
Date
Msg-id ncuu809i4hk7bt2qd644mp79icsprdhbkv@email.aon.at
Whole thread Raw
In response to Updates not atomic with respect to indexes  (Ben Young <ben@transversal.com>)
Responses Re: Updates not atomic with respect to indexes
List pgsql-general
Tree view 
On Wed, 28 Apr 2004 09:33:34 +0100, Ben Young <ben@transversal.com>
wrote:
>UPDATE temp SET num = num+1;
>ERROR:  duplicate key violates unique constraint "temp_num_key"

>Is this [...] a known problem in Posgresql,

Yes.

> or bug which will be fixed sometime.

Don't know.

If you need a workaround for now, do it in two steps:

    UPDATE temp SET num = -num;
    UPDATE temp SET num = -num+1;

This assumes you have a range of numbers that is normally not used.

Servus
 Manfred

pgsql-general by date:

Previous
From: "John Sidney-Woollett"
Date:
Subject: Re: Updates not atomic with respect to indexes
Next
From: Ian Ribas
Date:
Subject: Optimizer choosing smaller index instead of right one