On Tuesday 13 April 2010 6:03:43 am Satish Burnwal (sburnwal) wrote:
> controlsmartdb=# select * from pg_stat_activity where waiting='t';
>
> ERROR: column "waiting" does not exist
>
>
From here:
http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS
My guess is you are being caught by this;
pg_stat_activity
"Furthermore, these columns are only visible if the user examining the view is a
superuser or the same as the user owning the process being reported on. '
--
Adrian Klaver
adrian.klaver@gmail.com