Re: SELECT statements in log files

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: mario(dot)splivalo(at)mobart(dot)hr, pgsql-admin(at)postgresql(dot)org
Subject: Re: SELECT statements in log files
Date: 2006-03-04 07:41:00
Message-ID: 20060304074100.GA229@alamut
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2006-03-04 09:56:37 Re: PITR as Online Backup Solution
Previous Message Jim C. Nasby 2006-03-04 03:16:44 Re: PITR as Online Backup Solution