Small patch to replace 'idle' by 'trans' if transaction is still open

Christof Petig <christof.petig@wtal.de>

From: Christof Petig <christof.petig@wtal.de>
To: pgsql-patches@postgresql.org
Date: 2000-10-03T19:28:36Z
Lists: pgsql-hackers

Attachments

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