Re: prepared statements don't log arguments? - Mailing list pgsql-hackers

From Neil Conway
Subject Re: prepared statements don't log arguments?
Date
Msg-id 4254977B.5020600@samurai.com
Whole thread Raw
In response to Re: prepared statements don't log arguments?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: prepared statements don't log arguments?
Re: prepared statements don't log arguments?
Re: prepared statements don't log arguments?
List pgsql-hackers
Christopher Kings-Lynne wrote:
> I think he has a really excellent point.  It should log the parameters 
> as well.

neilc=# prepare foo(int, int) as select $1 + $2;
PREPARE
neilc=# execute foo(5, 10);
...
neilc=# execute foo(15, 20);
...

% tail /usr/local/pgsql/postmaster.log
LOG:  statement: prepare foo(int, int) as select $1 + $2;
LOG:  statement: execute foo(5, 10);
LOG:  statement: execute foo(15, 20);

-Neil


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: prepared statements don't log arguments?
Next
From: Alvaro Herrera
Date:
Subject: Shared row locking, revisited