Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 770586322A7 for ; Thu, 27 May 2010 14:25:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 22812-06; Thu, 27 May 2010 17:25:48 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14]) by mail.postgresql.org (Postfix) with ESMTP id 7057B63221C; Thu, 27 May 2010 14:25:48 -0300 (ADT) Received: by locust.cns.vt.edu (Postfix, from userid 986) id 4025C118969; Thu, 27 May 2010 13:25:47 -0400 (EDT) Date: Thu, 27 May 2010 13:25:47 -0400 From: Ray Stell To: Tom Lane Cc: alvherre , pgsql-admin , pgsql-hackers@postgresql.org Subject: Re: command tag logging Message-ID: <20100527172547.GA9472@cns.vt.edu> References: <20100526210833.GA14469@cns.vt.edu> <1274908611-sup-6661@alvh.no-ip.org> <3713.1274978989@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3713.1274978989@sss.pgh.pa.us> User-Agent: Mutt/1.5.17 (2007-11-01) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/272 X-Sequence-Number: 34745 On Thu, May 27, 2010 at 12:49:49PM -0400, Tom Lane wrote: > alvherre writes: > > Excerpts from Ray Stell's message of miƩ may 26 17:08:33 -0400 2010: > >> I just installed a compiled from src 8.3.11. I usually include %i, command tag, > >> in the log_line_prefix setting. This causes some spewage I'd not seen before > >> on connection received lines as if it is dumping the environment: > > > Hmm, I bet it's the recent %.*s patch. > > That is in the right place, isn't it. That would suggest that > get_ps_display() is returning a wrong length on Ray's machine. > It works okay here, but since that's platform-specific code that > hardly proves much. Ray, what platform is this exactly? I should have included this: version ----------------------------------------------------------------------------------------------------- PostgreSQL 8.3.11 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46) (1 row) [postgres ~]$ uname -a Linux horntail.cns.vt.edu 2.6.18-194.3.1.el5PAE #1 SMP Sun May 2 04:42:25 EDT 2010 i686 i686 i386 GNU/Linux [postgres ~]$ cat /etc/issue Red Hat Enterprise Linux Server release 5.5 (Tikanga) Kernel \r on an \m