Subject Referential Integrity, Multi-generational
Author Jim Starkey
I have been corrected. Ann's scenario:

Transaction 1: Adds child to parent
Transaction 2: Deletes parent
Transaction 1: Commit
Transaction 2: Commit

Result: an orphan.

I am informed that the Interbase system trigger operates under
special rules akin to the unique index enforcement rules.

Jim Starkey