prepared statements logging

From: marcofuics(at)netscape(dot)net
To: pgsql-admin(at)postgresql(dot)org
Subject: prepared statements logging
Date: 2007-04-11 07:35:55
Message-ID: 8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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. ====================================================
Marco Fulcoli Vincenzo
Astrophysical, Advanced_Computing_Tech

________________________________________________________________________
Check Out the new free AIM(R) Mail -- 2 GB of storage and industry-leading spam and email virus protection.

Browse pgsql-admin by date

  From Date Subject
Next Message Chuck Amadi 2007-04-11 08:36:57 Re: server startup script at boot
Previous Message Benjamin Krajmalnik 2007-04-10 23:42:02 Re: [pgadmin-support] Motivations for PostgreSQL