On Thu, 31 Mar 2011, Marc Mamin wrote:
>
>>> Achilleas Mantzios, 31.03.2011 09:58:
>> You mean log_line_prefix parameter. Ok but a
>> log_line_prefix = '%d %a %u %p %c %m '
>> while it prints correctly %a (application) (as set by SET application_name),
>> it does not print correctly %u (user) (as set by SET ROLE).
>
> I would not say that %u return an incorrect user as the info stay
> relevant after changing the connection role, but an additional parameter
> to log the current role would be indeed interesting.
>
A patch was worked on for the server for 9.1 to implement this, but it
didn't make it in, perhaps for 9.2...
https://commitfest.postgresql.org/action/patch_view?id=524
Kris Jurka