Re: BUG #2393: update fails with unique constraint violation

From: "T(dot)J(dot) Ferraro" <tjtoocool(at)phreaker(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2393: update fails with unique constraint violation
Date: 2006-04-15 13:56:13
Message-ID: 4440FB7D.2030301@phreaker.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Isn't that expected? Your query will try to update row 3 first and set
the primary key to 5, which in fact would violate the primary key
constraint on that table.

Laurence Dawson wrote:
> And then try an update:
> lstore=> select * from test.test;
> a
> ----
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> (10 rows)
>
> lstore=> update test.test set a = a + 2 where a >= 3;
> ERROR: duplicate key violates unique constraint "pk"
> lstore=>
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-04-15 14:04:56 Re: BUG #2393: update fails with unique constraint violation
Previous Message Harald Armin Massa 2006-04-15 13:54:01 Re: BUG #2393: update fails with unique constraint violation