Subject Re: [firebird-support] Re: SELECT WITH LOCK, WAIT transaction, deadlock
Author Gabor Boros
2016. 04. 28. 17:18 keltezéssel, Dmitry Yemanov
dimitr@... [firebird-support] írta:
> 28.04.2016 16:19, Gabor Boros wrote:
>> In the language reference for "isc_tpb_read_committed + isc_tpb_wait" I
>> see this: "Update conflict exceptions can never be raised by an explicit
>> lock statement in this TPB mode."
> This is true for two concurrent transactions but may fail for three or
> more concurrent transactions.

Your words shocked me. Firebird cannot handle more than two concurrent
transactions? What is the purpose of WITH LOCK if see deadlock with and
without it? I always used Firebird and don't know how other RDBMS
solutions work in this situation.