change format of logging statements?

From: Matthew Hixson <hixson(at)poindextrose(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: change format of logging statements?
Date: 2007-04-23 19:29:37
Message-ID: BCA522FE-C1D6-4F86-A19E-04FADC8B123B@poindextrose.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgres 8.2.0 is logging statements with variables like $1, $2, etc.
and then on the next line saying:

DETAIL: parameters: $1 = '100', $2 = '100', $3 = '1003'

Is it possible to get statements logged with the parameters placed
into the actual query statement so that its more convenient to copy
and paste them into psql while debugging? The reason for this is
that Hibernate is creating the queries and I'd like to see exactly
what those queries are returning.
Thanks,
-M@

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-04-23 19:41:04 Re: change format of logging statements?
Previous Message Vitaliyi 2007-04-23 18:55:10 Problem with encoding (lower() doesn't work)