Subject | Referential Integrity, Multi-generational |
---|---|
Author | Jim Starkey |
Post date | 2001-10-24T16:51:01Z |
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
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