Skip site navigation (1) Skip section navigation (2)

prepared statements logging

From: marcofuics(at)netscape(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: prepared statements logging
Date: 2007-04-11 07:40:03
Message-ID: 8C94A23C0563339-1128-62A0@webmail-de11.sysops.aol.com (view raw or flat)
Thread:
Lists: pgsql-novice
  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.

Responses

pgsql-novice by date

Next:From: RegiDate: 2007-04-11 09:40:10
Subject: Install question
Previous:From: kvnsmnsnDate: 2007-04-10 19:35:55
Subject: trying to connect to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group