As it turns out Mark Wong's pg_top project / branch
https://github.com/markwkm/pg_top/ has been patched and looks like it will
cope with the current column names and their previous incarnation.
I don't think I would ever have found it unless P. Christeas had pointed it
out. I cloned the source from git.postgresql.org which I assumed would be
the latest code....
Google searches point you mostly to pgfoundry, which seems to be out of date
(pg_top that is) and most links in the foundry take you to a "page not
found".
I suppose the question now is git.postgresql.org where I should expect to
find the latest code, stable or otherwise...
Thanks,
Brett
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Merlin Moncure
Sent: 20 December 2012 22:24
To: Tom Lane
Cc: John R Pierce; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] pg_top
On Thu, Dec 20, 2012 at 4:17 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> John R Pierce <pierce@hogranch.com> writes:
>> /me tossed another mumbled curse at whomever changed that field name.
>
> The reason for the field name change was that the semantics of the
> field changed. You typically ought to look at what the application is
> actually doing with the field, not just do s/current_query/query/g and
> expect that all will be well. (In particular, if the app is looking
> for "idle" or "idle in transaction" state markers, it's going to need
> more adjustment than that.)
IMSNHO, neither of these should have been changed, I would much rather have
seen a new view or some other way of opting into the new functionality.
merlin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers