Re: lock timeout patch

Tom,

I guess the transaction cancellation from the client
using PQrequestCancel() is available, but the cancellation
logic must be implemented in the client-application using
signal or thread.

I think detecting such situation on server-side is not
available now, and SQL Server or DB2 have same function.

Tom Lane wrote:
> Satoshi Nagayasu <nagayasus@nttdata.co.jp> writes:
> 
>>When a transaction is blocked by another transaction because of
>>waiting a lock, we need a lock timeout in some cases.
> 
> 
> Isn't there an existing solution for this problem?
> 
>             regards, tom lane
> 

-- 
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>