Bruce Momjian <[EMAIL PROTECTED]> writes:
> Now, if someone wanted to say CASCADE|RESTRICT was
> required for DROP _only_ if there is some foreign key references to the
> table, I would be OK with that, but that's not what the standard says.
But in fact that is not different from what I propose to do. Consider
what such a rule really means:
* if no dependencies exist for the object, go ahead and delete.
* if dependencies exist, complain.
How is that different from "the default behavior is RESTRICT"?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster