Re: Small patch to replace 'idle' by 'trans' if transaction is still open

On Fri, 19 Jan 2001, Bruce Momjian wrote:

>
> Seems we decided against this. Sorry.

Huh? from reading Tom's response, sounds like it would be something
useful? I know I find having as much information about state in the ps
listing helps me alot, and knowing if its 'idle' vs 'idle (in
transaction)' provides at lesat more detailed information then just 'idle'
...

Who was the 'we' in the above decision? Tom seemed in favor of it, I know
I'm in favor of it .. and you are not in favor of it ...

> > > Tom Lane wrote:
> >
> > > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > > I can't decide if this is of general use. My inclination is that
> > > > someone in a transaction sitting a prompt should still show as idle.
> > >
> > > The idea seemed good to me, although I didn't look at the code to see
> > > if the implementation was any good ;-). I know we've frequently had
> > > questions on the lists where it was interesting to know if any
> > > transactions were being held open --- and right now there's no easy
> > > way to tell.
> > >
> > > regards, tom lane
> >
> > I would even propose 'idle (transaction open)' if you agree. (Seemed too
> > long for me)
> > The patch is _trivial_ a string changed to a condifional operator and two
> > strings (two times). A two liner.
> >
> > Christof
> >
> >
> >
>
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org