Re: lock timeout patch

Поиск
Список
Период
Сортировка
От Satoshi Nagayasu
Тема Re: lock timeout patch
Дата
Msg-id 40DF9928.9010805@noanet06.noanet.nttdata.co.jp
обсуждение исходный текст
Ответ на Re: lock timeout patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: lock timeout patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: lock timeout patch
Следующее
От: Tom Lane
Дата:
Сообщение: Re: lock timeout patch