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' ham...@risingsoftware.com [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 hugoe...@msn.com<mailto:hugoe...@msn.com> [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