Re: [PATCHES] Small patch to replace 'idle' by 'trans' if transactionis still open

> Tom Lane writes:
>
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > Any solid consensus on this?
> >
> > I'm for it (given a short status string --- "idle in tx" or "idle in trans"
> > seem fine). Marc's for it. Who's against it?
>
> (I'm not.) If you're going to do "idle in trans" you might as well spell
> it out. The string will be truncated to the allowed length with no penalty.

OK, patch applied:

#$ ps -ax|grep post
27085 ?? Ss 0:00.05 ./bin/postmaster -B 384 -i -d0 -o -F -d0
27108 ?? S 0:00.04 postgres test [local] idle (postmaster)
27150 p7 S+ 0:00.01 grep post
#$ ps -ax|grep post
27085 ?? Is 0:00.05 ./bin/postmaster -B 384 -i -d0 -o -F -d0
27108 ?? S 0:00.04 postgres test [local] idle in transaction (postmaster
27185 p7 S+ 0:00.02 grep post
#$

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