Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Gabor Boros
2016. 04. 28. 17:46 keltezéssel, Thomas Steinmaurer ts@...
[firebird-support] írta:
> What happens if you are running Read Committed WITH record version?

No error with 10 concurrently instances of the test app (2 SQL lines
(SELECT ... WITH LOCK and UPDATE ...)). But failing with the real

Try to utilize WITH LOCK because I need many unique number generators in
a table field. Like a generator/sequence but under transaction control.