Subject Debugging cascaded updates
Author GrumpyRain
I need some suggestions here. I have a table whose primary key is the
foreign key in a number of other tables (about 30 or so). When I try
to delete a record from this table, I get a funny error message,
because one of the tables that relies on it has a bug in a before or
after delete trigger.

The other tables are all defined as "on delete cascade".

Is there any quick and easy way of finding which trigger is throwing
the error message, or is process of elimination the only way?

Thanks for your help