Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-10-10 00:17:14
Subject: Re: [GENERAL] Using BLOBs with PostgreSQL
Previous:From: Tim KientzleDate: 2000-10-10 00:06:37
Subject: Re: [GENERAL] Using BLOBs with PostgreSQL

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group