> hannu=# update t set i=i+1;
> ERROR: Cannot insert a duplicate key into unique index t_i_key
A possibility may be to reverse the sequential scan order for the simple
cases, but anything any more complex and the check should be deferred
till end of statement, rather than checking immediately.
-- Rod Taylor