BTW I also agree that this shoud throw FK voilation exception on detail insert.
-----Eredeti üzenet----- Feladó: Carlos H. Cantu [mailto:lis...@warmboot.com.br] Küldve: 2019. szeptember 6., péntek 14:13 Címzett: For discussion among Firebird Developers <firebird-devel@lists.sourceforge.net> Tárgy: Re: [Firebird-devel] Inserts and FKs MA> If you do master and detail in separate transaction then tx2 should MA> not be started before tx1, tx2 start MUST wait for tx1 SUCCESSFUL MA> commit, otherwise your business logis FLAWED. Tx2 wasn't start before tx1. Read again my first email. []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 __________ Information from ESET Mail Security, version of virus signature database 19976 (20190906) __________ The message was checked by ESET Mail Security. http://www.eset.com __________ Information from ESET Mail Security, version of virus signature database 19976 (20190906) __________ The message was checked by ESET Mail Security. http://www.eset.com Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel