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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Christof Petig <christof(dot)petig(at)wtal(dot)de>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date: 2000-10-10 02:46:56
Message-ID: 17221.971146016@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> 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.

The idea seemed good to me, although I didn't look at the code to see
if the implementation was any good ;-).  I know we've frequently had
questions on the lists where it was interesting to know if any
transactions were being held open --- and right now there's no easy
way to tell.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Marc G. FournierDate: 2000-10-10 03:48:03
Subject: [7.0.2] cannot create an index ...
Previous:From: Tom LaneDate: 2000-10-10 02:40:45
Subject: Re: Re: [GENERAL] Using BLOBs with PostgreSQL

pgsql-patches by date

Next:From: Peter EisentrautDate: 2000-10-10 15:52:01
Subject: Re: [PATCHES] Re: [ANNOUNCE] Announce: Release of PyGreSQL version 3.0
Previous:From: Bruce MomjianDate: 2000-10-10 00:16:16
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open

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