Re: 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,
Pennsylvania19026