>>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:
>>comm
Title: Re: ODP: [Firebird-devel] ODP: Inserts and FKs
If you wanna test, please use isql... I don't know how flamerobin deals with transactions internally.
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.