Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3BC4D2E2D44 for ; Tue, 13 Nov 2007 16:11:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 02818-02-6 for ; Tue, 13 Nov 2007 16:11:03 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id C5DF62E2E6C for ; Tue, 13 Nov 2007 16:10:59 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id lADKAuj27088; Tue, 13 Nov 2007 15:10:56 -0500 (EST) From: Bruce Momjian Message-Id: <200711132010.lADKAuj27088@momjian.us> Subject: Re: Escape string tracing In-Reply-To: <4739F979.8090100@sbcglobal.net> To: Mike Blackwell Date: Tue, 13 Nov 2007 15:10:56 -0500 (EST) CC: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/110 X-Sequence-Number: 27353 Mike Blackwell wrote: > I have a system that's been giving the nonstandard use of \\...' warning > in the postgresql log. Is there a way to get the SQL associated with > the warning without logging all the sql statements being processed? Yes, mark it as an escape string, E''. See the documentation and release notes. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +