|Subject||Re: [firebird-support] SELECT WITH LOCK, WAIT transaction, deadlock|
29.04.2016 11:26, Gabor Boros gaborboros@... [firebird-support] wrote:
> The transaction do other work before grab the number and after grab theYou need transaction with explicit exclusive lock on generator table.
> number. The whole thing is in a (one) stored procedure. (Works like a
> charm except deadlocks.)