Re: Small patch to replace 'idle' by 'trans' if transaction is still open - Mailing list pgsql-patches

From The Hermit Hacker
Subject Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date
Msg-id Pine.BSF.4.31.0101191418570.2503-100000@thelab.hub.org
Whole thread Raw
In response to Re: Small patch to replace 'idle' by 'trans' if transaction is still open  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Small patch to replace 'idle' by 'trans' if transaction is still open
List pgsql-patches
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@candle.pha.pa.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@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
>

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


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Next
From: Bruce Momjian
Date:
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open