Re: BUG #1754: Abou the pg_stat_activity

On Tue, Jul 05, 2005 at 02:06:58PM +0100, Ramzi wrote:
>
> I found a bug in my postgresql which is when I make this select command
> [select * from pg_stat_activity] it doesnt show me active current query, but
> in newer versions and on windows OS it shows the output for this.
> i need a help if it is really a bug, if there is a way to solve this problem
> on my 7.3 version because my current version is activated and live and hard
> to change to the newer one especially at this time.

Are you querying pg_stat_activity as a database superuser?  According
to the 7.4 Release Notes, ordinary users can see their own queries
only in 7.4 and later.

http://www.postgresql.org/docs/7.4/static/release-7-4.html#AEN62504

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/