The following bug has been logged online:

Bug reference: 1754
Logged by: Ramzi
Email address: ramzi.zeid (AT) beecell (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Tue, Jul 05, 2005 at 02:06:58PM +0100, Ramzi wrote:
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/s....html#AEN62504

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org