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: pgsql-patches(at)postgresql(dot)org
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date: 2000-10-10 00:16:16
Message-ID: 200010100016.UAA00109@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(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 Bruce Momjian 2000-10-10 00:17:14 Re: [GENERAL] Using BLOBs with PostgreSQL
Previous Message Tim Kientzle 2000-10-10 00:06:37 Re: [GENERAL] Using BLOBs with PostgreSQL

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2000-10-10 02:46:56 Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Previous Message Bruce Momjian 2000-10-09 23:16:53 Re: [PATCHES] Re: [ANNOUNCE] Announce: Release of PyGreSQL version 3.0