X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 13C649DCA1E for ; Sat, 4 Mar 2006 03:43:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78249-08 for ; Sat, 4 Mar 2006 03:43:23 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from fep02.ttnet.net.tr (mail.ttnet.net.tr [212.175.13.129]) by postgresql.org (Postfix) with ESMTP id D8A2D9DC8A1 for ; Sat, 4 Mar 2006 03:43:19 -0400 (AST) Received: from alamut ([85.96.109.238]) by fep02.ttnet.net.tr with ESMTP id <20060304074101.EKTM7467.fep02.ttnet.net.tr@alamut>; Sat, 4 Mar 2006 09:41:01 +0200 Date: Sat, 4 Mar 2006 09:41:00 +0200 From: Volkan YAZICI To: Simon Riggs Cc: mario.splivalo@mobart.hr, pgsql-admin@postgresql.org Subject: Re: SELECT statements in log files Message-ID: <20060304074100.GA229@alamut> References: <1141384781.8893.8.camel@localhost.localdomain> <1141410014.27729.521.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1141410014.27729.521.camel@localhost.localdomain> User-Agent: Mutt/1.4.2.1i X-NAI-Spam-Rules: 1 Rules triggered BAYES_00=-2.5 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.265 required=5 tests=[AWL=-0.533, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 2.265 X-Spam-Level: ** X-Archive-Number: 200603/46 X-Sequence-Number: 20803 On Mar 03 06:20, Simon Riggs wrote: > On Fri, 2006-03-03 at 12:19 +0100, Mario Splivalo wrote: > > When I connect to postgres from PHP or Python or using just psql, I can > > see full SELECT querries logged, with the actuall values for the > > parameters. > > Those interfaces do not use prepared statements, so are not logged in > the same way. IIRC, (in the Python side) both psycopg and pygresql modules don't support parameter usage yet. But with 5.1.0RC1 release of PHP, there're new functions available with parameter utilization. Regards.