Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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/


pgsql-bugs by date

Next:From: Hiroshi InoueDate: 2007-04-14 23:03:22
Subject: Re: BUG #3226: ODBC driver 8.02.02 parses subqueries incorrectly
Previous:From: Russell SmithDate: 2007-04-14 01:02:40
Subject: Re: BUG #3225: BitmapOr plan node does not show currect row count

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group