Re: [HACKERS] prepared statements logging
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Apr 10, 2007 at 02:53:32AM -0700, marcofuics wrote: > Hi * > I am using the postgresql-8.2.3, with a jdbc-8.2-504 (the GeoNet > webServer tool...) My question is : > Is the <> server able to log the whole <> query? > {made by a prepared statement} > Looking at the log I can see only queries of the type: > TIP 5: don't forget to increase your free space map settings Wrong list. This is one dedicated for people working on the innards of PostgreSQL. You'd want one of or <[EMAIL PROTECTED]>. Now to your question: there are many configuration parameters in the config file (possibly in /etc/postgresql/8.2/main/postgresql.conf or some similar location, depending on your OS and distribution) to control the level of logging. Look there for entries named log_xxx and debug_xxx. HTH - -- tomás -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFGHHpCBcgs9XrR2kYRAs4SAJ45gvCVcp4Avk4t7NgQ/SST0s35owCggdWQ CcVc9UluRe4d/Gl8ERV7z4I= =P8EJ -END PGP SIGNATURE- ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] prepared statements logging
Hi * I am using the postgresql-8.2.3, with a jdbc-8.2-504 (the GeoNet webServer tool...) My question is : Is the <> server able to log the whole <> query? {made by a prepared statement} Looking at the log I can see only queries of the type: (cut). LOG: execute : SELECT * FROM Metadata WHERE id=$1 DETAIL: parameters: $1 = '28' DEBUG: parse : SELECT schemaId, createDate, lastChangeDate, source, isTemplate, uuid FROM Metadata WHERE id = 28 (cut). The strange is that my query has to search on a "Test vector data" and in the whole log-file this word <> is not present! My desire is to have a line where I can see: SELECTbla..bla...bla FROM MetadataWHERE id = "...some pattern" [maybe islike some pattern] Thx in advance. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings