SET SESSION AUTHORIZATION and log file entries

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: SET SESSION AUTHORIZATION and log file entries
Date: 2010-12-29 14:06:41
Message-ID: 201012291606.41505.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
i noticed that the user name as displayed in the postgresql log (specified by %u) in the log_line_prefix
does not show the user name of the effective user (current_user)as set by "SET SESSION AUTHORIZATION"
but, instead, shows the initial user which first authenticated against the said connection.
I think it would be better to have this user reported in the log files. (or have another entry e.g. %U to denote that)
--
Achilleas Mantzios

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Rericha 2010-12-29 17:11:39 Re: date out of range for timestamp
Previous Message Tom Lane 2010-12-29 03:06:13 Re: date out of range for timestamp