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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Christof Petig <christof(dot)petig(at)wtal(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date: 2001-01-19 17:25:18
Message-ID: 200101191725.MAA27770@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Seems we decided against this. Sorry.

> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2001-01-19 17:37:02 Re: child table doesn't inherit PRIMARY KEY?
Previous Message Bruce Momjian 2001-01-19 17:03:58 Re: Possible performance improvement: buffer replacement policy

Browse pgsql-patches by date

  From Date Subject
Next Message The Hermit Hacker 2001-01-19 18:21:00 Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Previous Message Bruce Momjian 2001-01-19 16:40:54 Re: Re: [PATCHES] s_lock.h cleanup