On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane wrote:
> Craig James writes:
> > I installed 9.2 on our new server and am seeing something odd that
> doesn't
> > happen in 8.4:
>
> > postgres=# select datname, pid, usename, query from pg_stat_activity
> where
> > query != '';
>
> The query column now
Craig James writes:
> I installed 9.2 on our new server and am seeing something odd that doesn't
> happen in 8.4:
> postgres=# select datname, pid, usename, query from pg_stat_activity where
> query != '';
The query column now means "current or last query" --- there's a
separate column to check
I installed 9.2 on our new server and am seeing something odd that doesn't
happen in 8.4:
postgres=# select datname, pid, usename, query from pg_stat_activity where
query != '';
datname | pid | usename |
query
+---+--+-
