Jeff Davis <pg...@j-davis.com> wrote: > On Fri, 2011-04-01 at 13:00 -0400, Dan Ports wrote: >> While looking into a SSI bug, I noticed that we don't actually >> display the pid of the holding transaction, even though we have >> that information available. > > Is there a chance that the PID will reference a backend that has > either terminated or is idle? Yes to both. > That might be confusing. With a barely larger patch we could suppress that, if that's desirable. Of course, there is already the same issue for the virtualtransaction column. As Dan mentioned, it won't show for locks which are summarized using SLRU, nor will it show for prepared transactions pending final commit -- at least if they're loaded from disk after recovery. (I'm not sure without some digging about a transaction which is prepared and still pending commit if the server is still running from the point of prepare.) -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers