Subject Re: [firebird-support] a doubt about "cascade" triggers & exceptions
Author Martijn Tonies
> Hello, I want to do some AFTER_DELETE triggers on
> some tables to clean some other tables and to check if the delete can be
> TABLE1_AFTER_DELETE runs a delete on TABLE2 or raises an exception,
depending on
> some condition.
> TABLE2_AFTER_DELETE runs a delete on TABLE3 or raises an exception...
> if TABLE3_AFTER_DELETE raises an exception, would all the previous delete
> statement be rolled back?

Yes, UNLESS you've got an exception handling block in your trigger that
catches your exception and eats it. Yummy.

> By the way: which is the best way to do this task? ISTR (don't remember
> I read it) that is better to use triggers than foreign key to mantain the
> consistence. Is it right? Or should I create all FK for this cases?

Personally, I mostly use FKs.

>And with FK,
> a fail in the last delete, would rollback al the previous ones?


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!