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

From Christopher Kings-Lynne
Subject Re: prepared statements don't log arguments?
Date
Msg-id 425493EA.9040601@familyhealth.com.au
Whole thread Raw
In response to Re: prepared statements don't log arguments?  (Greg Stark <gsstark@mit.edu>)
Responses Re: prepared statements don't log arguments?  (Neil Conway <neilc@samurai.com>)
List pgsql-hackers
>>postgres[30059]: [97-1] LOG:  statement: INSERT INTO group_data (this_group_id,
>>item_text, link_path) VALUES ($1, $2, $3)
>>
>>I really need to know the *real* arguments... How can I get them? Is it a bug?
> 
> 
> The bug was that prepared statements didn't work properly in the past. That is
> the statement you're actually running.
> 
> You might want to look into JDBC options to disable use of prepared
> statements. The old emulation code must still be there in case it runs against
> a <=7.4 database so perhaps there's an option to use it.

I think he has a really excellent point.  It should log the parameters 
as well.

Chris


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Recognizing range constraints (was Re: [PERFORM] Plan for
Next
From: Neil Conway
Date:
Subject: Re: prepared statements don't log arguments?