prepared statements logging
От | marcofuics |
---|---|
Тема | prepared statements logging |
Дата | |
Msg-id | 1176198812.784939.96800@b75g2000hsg.googlegroups.com обсуждение исходный текст |
Ответы |
Re: prepared statements logging
|
Список | pgsql-hackers |
Hi * I am using the postgresql-8.2.3, with a jdbc-8.2-504.... (the GeoNet webServer tool...) My question is : Is the <<PostGresDB>> server able to log the whole <<SELECT>> query? {made by a prepared statement????} Looking at the log I can see only queries of the type: (cut)............. LOG: execute <unnamed>: SELECT * FROM Metadata WHERE id=$1 DETAIL: parameters: $1 = '28' DEBUG: parse <unnamed>: 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 <<Test>> is not present! My desire is to have a line where I can see: SELECT bla..bla...bla FROM Metadata WHERE id = "...some pattern...." [maybe islike some pattern] Thx in advance.
В списке pgsql-hackers по дате отправления: