Re: prepared statements don't log arguments?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: prepared statements don't log arguments?
Date: 2005-04-07 01:59:06
Message-ID: 425493EA.9040601@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-04-07 02:14:19 Re: prepared statements don't log arguments?
Previous Message Neil Conway 2005-04-07 01:57:13 Re: DELETE ... USING