Subject Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock
Author Dimitry Sibiryakov
29.04.2016 11:26, Gabor Boros gaborboros@... [firebird-support] wrote:
> The transaction do other work before grab the number and after grab the
> number. The whole thing is in a (one) stored procedure. (Works like a
> charm except deadlocks.)

You need transaction with explicit exclusive lock on generator table.