On 20/01/14 Michael P. Soulier said:
> This violates the uniquness constraint. Is there a way to say, turn off the
> constraint, run the update and then turn it back on?
Hmm. This didn't work.
tugdb=# SET CONSTRAINTS ALL DEFERRED;
SET CONSTRAINTS
tugdb=# update siptrunkroutingrules set rule_number = rule_number + 1;
ERROR: duplicate key value violates unique constraint
"siptrunkroutingrules_unique_trunk_rule_number"
Mike