pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: marcofuics@netscape.net
To: pgsql-admin@postgresql.org
Subject: prepared statements logging
Date: Wed, 11 Apr 2007 03:35:55 -0400
Message-ID: <8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com> (raw)

  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.

Message-ID: <8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com>
Permalink:  ../8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com/
Also on:    postgresql.org/message-id/8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: marcofuics@netscape.net
  Subject: Re: prepared statements logging
  In-Reply-To: <8C94A232CA99519-1128-6297@webmail-de11.sysops.aol.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox