"Michael P. Soulier" <michael_soulier@xxxxxxxxx> writes: > 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" You'd have had to mark the index constraint as deferrable for that to have any effect on it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
