To log all queries - in your postgresql.conf file, set the following: log_statement = true
Mark wrote:
Hi, I'm getting some errors in log file saying "invalid character at position #20..." I know that this is most likely that query is wrong.
Is it possible to capture all queries that get send or at least the invalid queries?
I'm using postgresql 7.4.3 on Red Hat 9
Thanks, Mark
__________________________________ Do you Yahoo!? The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
--
Brad Nicholson 416-673-4106 bnichols@xxxxxxxxxxxxxxx
Database Administrator, Afilias Canada Corp.
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
