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

You may want to suggest to the devs to extend the "UPDATE" syntax with
"ORDER BY"? such that:

update rumple.directory
 set right_visit_id = right_visit_id + 2
 where right_visit_id >= parent_right
ORDER BY right_visit_id DESC;

...would work by enforcing a certain update order.  And index scan is
performed anyway because of the 'where' clause, might as well do it in
order. :)

MySQL does it like that AFAIK.

V.