prepared statements logging

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux