diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-20 18:51:16 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-20 18:51:16 +0000 |
| commit | db5d7ccac99e4b1f3ea0d09f7fc1b6f0682f336d (patch) | |
| tree | eb785027752bc54f832cac19480789f80f4f50ca /src/backend/utils/adt/pgstatfuncs.c | |
| parent | bd18c50ba87f12d1dc0aa65c1ff0507b2d1c5c41 (diff) | |
| download | postgresql-db5d7ccac99e4b1f3ea0d09f7fc1b6f0682f336d.tar.gz postgresql-db5d7ccac99e4b1f3ea0d09f7fc1b6f0682f336d.zip | |
It would also be handy if users could see their own pg_stat_activity
queries while the rest remain blank.
Kevin Brown
Diffstat (limited to 'src/backend/utils/adt/pgstatfuncs.c')
| -rw-r--r-- | src/backend/utils/adt/pgstatfuncs.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backend/utils/adt/pgstatfuncs.c b/src/backend/utils/adt/pgstatfuncs.c index 455da1c2aa9..c2f0ea2c829 100644 --- a/src/backend/utils/adt/pgstatfuncs.c +++ b/src/backend/utils/adt/pgstatfuncs.c @@ -284,14 +284,14 @@ pg_stat_get_backend_activity(PG_FUNCTION_ARGS) int len; text *result; - if (!superuser()) - PG_RETURN_NULL(); - beid = PG_GETARG_INT32(0); if ((beentry = pgstat_fetch_stat_beentry(beid)) == NULL) PG_RETURN_NULL(); + if (!superuser() && beentry->userid != GetUserId()) + PG_RETURN_NULL(); + len = strlen(beentry->activity); result = palloc(VARHDRSZ + len); VARATT_SIZEP(result) = VARHDRSZ + len; |