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
signature.asc
Description: Digital signature
