I just tested with FB 3 and it is the same (wrong, imho) behavior as FB 2.5.
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
| >>tx1 starts (read commited) >>tx1 INSERT INTO A (ID) VALUES (1); >>tx2 starts (snapshot isolation) - How did you started tx2? If you are in isql, you need at last to run some statement, like a select, to actually start a transaction. For example, run this on the >>second isql section: >>commit; -- making sure that if there is a transaction started, it will be closed now >>select * from a; -- Doing this you are actually starting a transaction (tx2) >>tx1 commits >>tx2 INSERT INTO B (ID, ID_A) VALUES (1, 1); >>tx2 commits – i have an error here! violation of FOREIGN KEY constraint "FK_B__A" on table "B" Foreign key reference target does not exist Problematic key value is ("ID_A" = 1) >>or transaction wait if i specifi wait for locks. >>I tested your steps (following my comments above) and get no error (FB 2.5). I have tested this by 2 instances of Flamerobin. But i have tested this under FB3 (WI-V3.0.4.32989 Firebird 3.0) not 2.5. I have not 2.5 installed as i have migrated all to FB3. Regards, Karol Bieniaszewski |
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
