Re: AW: AW: timeout on lock feature - Mailing list pgsql-hackers

From Henryk Szal
Subject Re: AW: AW: timeout on lock feature
Date
Msg-id 9bjk82$1ipt$1@news.tht.net
Whole thread Raw
In response to RE: AW: AW: timeout on lock feature  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
Responses Re: Re: AW: AW: timeout on lock feature  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Hi,

for 10 years i develop DB application using 'timeout on lock' feature
(Informix,Ingres,AdabasD,RDB,...).
I think about migrate with this application to postgresql, and with this
feature i don't need to modify my ready to run code specially for
postgresql. This feature guard me against blocking terminals, because long
query
initialized by operator (or administrator).

"Mikheev, Vadim" wrote in message
<8F4C99C66D04D4118F580090272A7A234D33AC@sectorbase1.sectorbase.com>...
>> > The timeout will be useful to let the client or user decide
>> > on an alternate course of action other that killing his
>> > application (without the need for timers or threads in the
>> > client program).
>>
>> This assumes (without evidence) that the client has a good
>> idea of what the timeout limit ought to be. I think this "feature"
>> has no real use other than encouraging application programmers to
>> shoot themselves in the foot. I see no reason that we should make
>> it easy to misdesign applications.
>
>AFAIR, Big Boys have this feature. If its implementation is safe,
>ie will not affect applications not using it, why do not implement it?
>
>Vadim
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://www.postgresql.org/search.mpl




pgsql-hackers by date:

Previous
From: "Sergiy Ovcharuk"
Date:
Subject: get difference between two timestamp value in second?
Next
From: "Henryk Szal"
Date:
Subject: Re: AW: timeout on lock feature