pg_stat_activity feature or bug?

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/

Browse pgsql-bugs by date

  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