Re: lock timeout patch - Mailing list pgsql-hackers

From Satoshi Nagayasu
Subject Re: lock timeout patch
Date
Msg-id 40DF9928.9010805@noanet06.noanet.nttdata.co.jp
Whole thread Raw
In response to Re: lock timeout patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: lock timeout patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock timeout patch
Next
From: Tom Lane
Date:
Subject: Re: lock timeout patch