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

From Bruce Momjian
Subject Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date
Msg-id 200010100016.UAA00109@candle.pha.pa.us
Whole thread Raw
In response to Small patch to replace 'idle' by 'trans' if transaction is still open  (Christof Petig <christof.petig@wtal.de>)
Responses Re: Small patch to replace 'idle' by 'trans' if transaction is still open  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Christof Petig
Date:
Subject: Small patch to replace 'idle' by 'trans' if transaction is still open
Next
From: Tom Lane
Date:
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open