| Hi "tx2 inserts a detail record in TableB Trigger on TableB tries to update master record, since the record is still not visible for this snapshot, update has null effect" I do not understand this point. If table B i detail it can only insert record for visible to it record in master. Or do you in your trigger you update whole table master not only master record of this detail? |
Trigger updates only the master record. The problem is exactly the fact that the insert of the detail record doesn't fail, because FK is out of transaction control so it can see the master record (but the update can't see it).
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
