On Wed, 28 Apr 2004 09:33:34 +0100, Ben Young <ben(at)transversal(dot)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