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 <[EMAIL PROTECTED]> To: pgsql-general@postgresql.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 [EMAIL PROTECTED] ----------------------------------------------------------------------------------------------- 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" ----------------------------------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match