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: | Raw Message | Whole Thread | 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 |