Στις Thursday 31 March 2011 17:47:36 ο/η Kris Jurka έγραψε:
>
> 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
Cool, thanks Kris.
>
> Kris Jurka
>
--
Achilleas Mantzios