| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2000-10-13 01:59:09 | Re: Small patch to replace 'idle' by 'trans' if transaction is still open |
| Previous Message | Mikheev, Vadim | 2000-10-12 23:34:00 | RE: backup and restore |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Warner | 2000-10-13 01:59:09 | Re: Small patch to replace 'idle' by 'trans' if transaction is still open |
| Previous Message | Bruce Momjian | 2000-10-11 18:10:23 | Re: [PATCHES] PgAccess schema-diagram cleanup |