| From: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | pg_stat_activity feature or bug? |
| Date: | 2007-04-14 04:17:28 |
| Message-ID: | 20070414041728.GC19347@timbira.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
The user in pg_stat_activity does not change when use the 'set session
authorization' command. So we couldn't track the real user. Is it a bug
or a feature?
regression=# select usesysid,usename,datname from pg_stat_activity;
usesysid | usename | datname
----------+----------+------------
10 | postgres | regression
(1 registro)
regression=# set session authorization timbira;
SET
regression=> select usesysid,usename,datname from pg_stat_activity;
usesysid | usename | datname
----------+----------+------------
10 | postgres | regression
(1 registro)
regression=>
--
Euler Taveira de Oliveira
http://www.timbira.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2007-04-14 23:03:22 | Re: BUG #3226: ODBC driver 8.02.02 parses subqueries incorrectly |
| Previous Message | Russell Smith | 2007-04-14 01:02:40 | Re: BUG #3225: BitmapOr plan node does not show currect row count |