Horton

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

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, The Hermit Hacker <scrappy@hub.org>, Christof Petig <christof@petig-baender.de>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, pgsql-patches@postgresql.org
Date: 2001-01-24T15:53:43Z
Lists: pgsql-hackers

Attachments

> Tom Lane writes:
> 
> > Bruce Momjian <pgman@candle.pha.pa.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@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