Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I assume MODIFY would allow you to alter the constraint without
> re-checking all the rows, as would be required by DROP/ADD. However, if
> you are modifying the constraint, wouldn't we have to recheck all the
> rows anyway.
Yeah. Rod's point about altering foreign key action settings is a good
one, but other than that I don't see a whole lot of scope for shortcuts.
regards, tom lane