Thread: Logging

Logging

From
cjobbers@optonline.net
Date:
I'm using VB.NET beta 2 over a Postgres DB. Whenever I read the log files created by PG, I never see the parameterized
queries.I only see $1 and $2 and so forth.  

Example:
"SELECT * FROM Accounts WHERE Account.Name = $1 AND rulename = $2"

How can I see the true value, not the alias?


Re: Logging

From
"A. Kretschmer"
Date:
am  13.11.2005, um 15:58:06 -0500 mailte cjobbers@optonline.net folgendes:
> I'm using VB.NET beta 2 over a Postgres DB. Whenever I read the log files created by PG, I never see the
parameterizedqueries. I only see $1 and $2 and so forth.  
>
> Example:
> "SELECT * FROM Accounts WHERE Account.Name = $1 AND rulename = $2"

Which version? I'm sure, with 8.x you can see the parameters.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===