Re: R: Problem with row-level lock

2019-06-21 Thread Adrian Klaver
On 6/21/19 1:40 AM, Job wrote: Dear Adrian, thank you for the reply! i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table. What is the error message you get? We have no error, but the two queries, in "Lock wait", keep stucked for some mi

R: Problem with row-level lock

2019-06-21 Thread Job
Dear Adrian, thank you for the reply! >> i am struggling with a problem due, sometime, to a double concurrent update >> on the same row of a table. >What is the error message you get? We have no error, but the two queries, in "Lock wait", keep stucked for some minutes before completed. Are th

Re: Problem with row-level lock

2019-06-20 Thread Adrian Klaver
On 6/19/19 9:06 AM, Job wrote: Hi guys, i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table. What is the error message you get? Since the client application cannot be control, i need to manage - in order to avoid this situation - the lock

Problem with row-level lock

2019-06-19 Thread Job
Hi guys, i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table. Since the client application cannot be control, i need to manage - in order to avoid this situation - the lock of a record due to two updates at the same time. Is there way to force