pg_stat_activity feature or bug? - Mailing list 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/