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: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-13 01:53:15
Message-ID: 200010130153.VAA02851@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
> At 11:15 11/10/00 -0400, Tom Lane wrote:
> >
> >There was another thread recently about adding a SHOW command or some
> >such to dump out the state of the lock manager's table in a readable
> >form.  I think that'd be a more useful thing to work on than trying
> >to cram one or two bits' worth of info into the ps display.
> >
> 
> Absolutely. I assume from this that the nature and state of all locks are
> stored in shared memory somewhere, and that the data is able to be
> interpreted without reference to non-shared data. If so, this would seem to
> be (a) a very useful thing to have and (b) not too hard. Is that right?
> 

Added to TODO:

	* Add SHOW command to display locks

-- 
  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

pgsql-hackers by date

Next:From: Philip WarnerDate: 2000-10-13 01:59:09
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Previous:From: Mikheev, VadimDate: 2000-10-12 23:34:00
Subject: RE: backup and restore

pgsql-patches by date

Next:From: Philip WarnerDate: 2000-10-13 01:59:09
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Previous:From: Bruce MomjianDate: 2000-10-11 18:10:23
Subject: Re: [PATCHES] PgAccess schema-diagram cleanup

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