incrementing without violating a constraint

["Michael P. Soulier" <michael_soulier@xxxxxxxxx>]

Hi,

I have a uniqueness constraint on an integer value in a table where I would
like to mass increment all of the existing rows.

ie.
update rules set rule_number = rule_number + 1;

This violates the uniquness constraint. Is there a way to say, turn off the
constraint, run the update and then turn it back on?

Thanks,
Mike

Attachment: signature.asc
Description: Digital signature