Subject Preventing cascading deletes
Author Robert Munro
Is there any way to temporarily prevent cascading deletes?

The situation is that in general when the user is using the product,
I want deletes from a particular table to cascade, but when automated
updates happen, if a delete has to cascade it means that the
automated process has missed something.

Is there a way to turn off cascaded deletes for a particular
connection or user? I suppose I could write my own on delete triggers
to do the cascade, but that would make it harder for tools to see
which tables cascade and which don't.

Thanks,

Robert Munro