From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Doug Easterbrook <doug(at)artsman(dot)com> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: server status window - query is not clearing one SQL is finished (change in behaviour) |
Date: | 2012-09-17 20:57:16 |
Message-ID: | 1347915436.2019.24.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Sun, 2012-09-16 at 07:26 -0600, Doug Easterbrook wrote:
> just to add to this change in behaviour
>
> if I use pgadmin 1.16 against a 9.1.5 database, the current_query goes blank when the query finished. So the behaviour clearly changes when it is pgadmin against a 9.2 database.
>
>
> just to make sure, I had a look at http://www.postgresql.org/docs/9.2/static/release-9-2.html and there is a little comment in the release notes
>
> E.1.2.6. Monitoring
>
>
> Rename pg_stat_activity.current_query to query because it is not cleared when the query completes (Magnus Hagander)
>
>
>
>
>
> which implies the change in behaviour is clearly the result of a change in postgres 9.2 and not due to a change in pgAdmin.
>
True.
> however, I would like to ask that you consider implementing the case statement in pgAdmin to clear the query if there is nothing running. its so handy when programming to see something finish and clear.
>
Won't happen though. When the query is finished, the state is set to
idle, which is enough to know that the query is done. BTW, I don't want
to change this because it's really to know which was the last executed
query (especially in a "idle in transaction" state, but not only in this
case).
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Serodio (lists) | 2012-09-17 21:16:32 | Re: RFE: Alises in WHERE clauses |
Previous Message | Raymond O'Donnell | 2012-09-17 20:46:28 | Re: RFE: Alises in WHERE clauses |