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