Subject | Preventing cascading deletes |
---|---|
Author | Robert Munro |
Post date | 2002-11-28T16:01:08Z |
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
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