Re: pg_top

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(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Merlin Moncure
Sent: 20 December 2012 22:24
To: Tom Lane
Cc: John R Pierce; pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] pg_top

On Thu, Dec 20, 2012 at 4:17 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> John R Pierce <pierce(at)hogranch(dot)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(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers