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

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