Re: prepared statements don't log arguments?

Palle Girgensohn <girgen@pingpong.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