Logging prepared statements in 8.1?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging prepared statements in 8.1?
Date: 2005-11-23 08:56:08
Message-ID: 43842EA8.5090604@havleik.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Trying again, since it appears that my mail never reached the list...

-------- Original Message --------
Subject: Logging prepared statements in 8.1?
Date: Wed, 23 Nov 2005 07:32:37 +0100
From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: pgsql-general(at)postgresql(dot)org

I am upgrading from 7.4 to 8.1 and there seems to have been a change in how postgresql log prepared
sql statements.. Before I could see the actual statements (i.e. after every parameters had been
changed with real values) but now I see the sql statements before the change (i.e with $1, $2 as
parameters)..

Is there a way to see the actual statements in 8.1?

Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj(at)havleik(dot)no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message tschak 2005-11-23 09:20:10 Re: Set Returning Function (Pipelining)
Previous Message Oleg Bartunov 2005-11-23 07:57:26 Re: tsearch2: more than one index per table?