> > 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

Tue, 17 Apr 2001 11:12:08 -0700
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: AW: AW: timeout on lock feature 
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



Wed, 18 Apr 2001 10:53:20 +0200
"Henryk Szal" <szal@doctorq.com.pl>
Re: AW: AW: timeout on lock feature
OK, we have it on the TODO list, so it will hopefully be added soon, in
some fashion.  I like the SET or the BEGIN TIMEOUT options.

> 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
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 19 Apr 2001 11:21:02 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Re: AW: AW: timeout on lock feature