| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Ramzi <ramzi(dot)zeid(at)beecell(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1754: Abou the pg_stat_activity |
| Date: | 2005-07-05 13:48:13 |
| Message-ID: | 20050705134813.GA91794@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2005-07-05 14:30:14 | Re: extract epoch bug |
| Previous Message | Frank van Vugt | 2005-07-05 13:10:33 | 'create or replace <function>' failed to replace trigger properly |