The following bug has been logged on the website: Bug reference: 8212 Logged by: Geoff Montee Email address: geoff.mon...@gmail.com PostgreSQL version: 9.2.4 Operating system: Linux Description:
When a user calls a function that has SECURITY DEFINER set, the value of "current_user" is changed to the name of the role that defined the function. For some use cases, it would be useful to be able to obtain the original value of "current_user" from within the function. Specifically, this would make sense in trigger functions used for auditing, where recording only session_user may not be sufficient. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs