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?If 
you update whole table, than you have hole in your bussiness logic, as you must 
run same update not only in triggers on detail but also in triggers on master 
table.This can cause same deadlocks but prevent inconsistent data.Regards,Karol 
Bieniaszewski
null
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to