vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
| Thread Tools | |
| Display Modes | |
|
|