| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
| Cc: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: JDBC gripe list |
| Date: | 2011-03-31 14:47:36 |
| Message-ID: | alpine.BSO.2.00.1103311046270.25650@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2011-03-31 14:58:31 | Re: JDBC gripe list |
| Previous Message | Quartz | 2011-03-31 14:40:08 | Re: JDBC gripe list (the autocommit subthread) |