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

From Tom Lane
Subject Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Date
Msg-id 2521.971540870@sss.pgh.pa.us
Whole thread Raw
In response to Re: Small patch to replace 'idle' by 'trans' if transaction is still open  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-patches
Philip Warner <pjw@rhyme.com.au> writes:
> Sounds like a good start. But would it be possible/desirable for a utility
> program to map the lock manager tables directly?

The utility program would have to be able to attach to the shared memory
segments holding the locktable and associated spinlocks.  And if you
did it that way, you couldn't inspect the locktable remotely without
duplicating a bunch more postmaster/backend code.  Offhand it seems to
me that "start an additional backend and use it to look at the
locktable" is the best way to approach this.

This does raise an interesting point though: do we need any security on
this new SHOW command?  Like, say, only allow it to superusers?

            regards, tom lane

pgsql-patches by date:

Previous
From: Philip Warner
Date:
Subject: Re: Small patch to replace 'idle' by 'trans' if transaction is still open
Next
From: Philip Warner
Date:
Subject: Re: src/backend/commands/sequence.c