From: | "marcofuics" <marcofuics(at)netscape(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | prepared statements logging |
Date: | 2007-04-10 09:53:32 |
Message-ID: | 1176198812.784939.96800@b75g2000hsg.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas ADI SD | 2007-04-10 10:01:21 | Re: Group Commit |
Previous Message | NikhilS | 2007-04-10 08:20:16 | Re: CREATE TABLE LIKE INCLUDING INDEXES support |