If somebody can readily clarify for me, you'll save me the trouble of a test. With our triggers that just set deleted = true for copies instead of actually allowing them to be deleted for the most part, will that cascade on delete ever really be invoked? If not, then I suppose it's worth it to remove the FK constraint in this case.
If somebody can readily clarify for me, you'll save me the trouble of a test. With our triggers that just set deleted = true for copies instead of actually allowing them to be deleted for the most part, will that cascade on delete ever really be invoked? If not, then I suppose it's worth it to remove the FK constraint in this case.