Thread: BUG #1754: Abou the pg_stat_activity
The following bug has been logged online: Bug reference: 1754 Logged by: Ramzi Email address: ramzi.zeid@beecell.com PostgreSQL version: 7.3 Operating system: Linux Description: Abou the pg_stat_activity Details: hello, 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. i hope that you can help me on this. best regards Ramzi
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/