Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> 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.
Agreed. Added to TODO:
o Allow ALTER TABLE to change constraint deferrability and actions
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
