Postgres Pro
Downloads
Home   >   mailing lists

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

From Christof Petig
Subject Small patch to replace 'idle' by 'trans' if transaction is still open
Date
Msg-id 39DA3363.216F7009@wtal.de
Whole thread Raw
Responses Re: Small patch to replace 'idle' by 'trans' if transaction is still open  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Tree view 
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
Attachment

pgsql-patches by date:

Previous
From: Jaap Boender
Date:
Subject: Compile problems on NetBSD/alpha 1.4.2 (and partial solution)
Next
From: Bruce Momjian
Date:
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open