Re: [firebird-support] how to resolve this deadlock

['Hamish Moffatt' ham...@risingsoftware.com [firebird-support]]

On 10/09/18 22:52, Hugo Eyng 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