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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
