Subject RE: [firebird-support] how to resolve this deadlock
Author Hugo Eyng
Post date 2018-09-13T18:06:44Z
Hi Hamish.

I don't intend to be obvious, but would it be possible to check record existence before inserting?


Atenciosamente,

+ + Hugo Eyng + +
De: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com> em nome de 'Hamish Moffatt' hamish@... [firebird-support] <firebird-support@yahoogroups.com>
Enviado: quarta-feira, 12 de setembro de 2018 00:50
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] how to resolve this deadlock
 
 

On 10/09/18 22:52, Hugo Eyng hugoeyng@... [firebird-support] wrote:
 

Hi Hamish.

I am not sure if I understood clearly your problem. If I did, you probably should use "WITH LOCK" clause.

Thanks Hugo, that might work. But as the row might not exist yet, I would have to lock the whole table, else the two inserts could still run simultaneously and conflict.


Hamish