Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Bruce Momjian <pgman@candle.pha.pa.us>
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Christof Petig <christof.petig@wtal.de>
Cc: pgsql-patches@postgresql.org
Date: 2000-10-10T00:16:16Z
Lists: pgsql-hackers
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. > If you are looking for programs which tend to hold longstanding > transactions, this micro patch might be handy. > Whether it is of general use is debatable. It will replace 'idle' by > 'trans' if the backend is idle but a transaction is pending. > > Simply use ps to view the backend's status. > > Christof [ application/x-gzip is not supported, skipping... ] -- 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