Victor Wagner writes:
> create table a (a numeric primary key);
> insert into a values (1);
> insert into a values (2);
> insert into a values (3);
> insert into a values (4);
> update a set a=a+1 where a>2;
> ERROR: Cannot insert a duplicate key into unique index a_pkey
This is a known problem with unique contraints, but it's not easy to fix
it.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter