Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 714621337B5C for ; Wed, 29 Dec 2010 10:06:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 13939-10 for ; Wed, 29 Dec 2010 14:06:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smadev.internal.net (host3.dynacom.ondsl.gr [62.103.35.211]) by mail.postgresql.org (Postfix) with ESMTP id 56C571337B67 for ; Wed, 29 Dec 2010 10:06:45 -0400 (AST) Received: from smadev.internal.net (localhost.internal.net [127.0.0.1]) by smadev.internal.net (8.14.2/8.14.2) with ESMTP id oBTE6gxt012310 for ; Wed, 29 Dec 2010 16:06:42 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Received: from localhost (localhost [[UNIX: localhost]]) by smadev.internal.net (8.14.2/8.14.2/Submit) id oBTE6fmt012309 for pgsql-admin@postgresql.org; Wed, 29 Dec 2010 16:06:41 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: SET SESSION AUTHORIZATION and log file entries Date: Wed, 29 Dec 2010 17:06:41 +0300 User-Agent: KMail/1.9.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201012291606.41505.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.451 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_BRBL_LASTEXT=1.449 X-Spam-Level: X-Archive-Number: 201012/206 X-Sequence-Number: 36435 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