Re: prepared statements don't log arguments?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: prepared statements don't log arguments?
Date: 2005-04-06 14:39:15
Message-ID: 8764z0nf58.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Palle Girgensohn <girgen(at)pingpong(dot)net> writes:

> When setting log_statement = all, and using JDBC PreparedStatements, I get $n
> in the log where the real arguments used to be in previous versions of
> postgresql:
>
> 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.

--
greg

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-04-06 15:07:02 Re: 8.0.2 beta announcement??
Previous Message Heikki Linnakangas 2005-04-06 13:59:47 Re: Two phase commit