Dave Page wrote:
Hi Andreas,
It was pointed out to me that the server status lock tab doesn't show data
correctly - specifically, the username is always blank, and the query string
normally shows up as <backend information unavailable>.
It seems the cause is that most of the stats functions don't take a PID as
an argument, but a backend ID between 1 and the current number of backends.
A hacked together replacement query looks like the following, but before I
appy it I just wanted to run it past you and the list in case I missed
anything:
Arg....
Testing for HOURS, coding it but you already committed it...
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
