Re: [HACKERS] prepared statements logging

2007-04-10 Thread tomas
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On Tue, Apr 10, 2007 at 02:53:32AM -0700, marcofuics wrote:
> Hi *
> I am using the postgresql-8.2.3, with a jdbc-8.2-504 (the GeoNet
> webServer tool...) My question is :
> Is the <> server able to log the whole <> query?
> {made by a prepared statement}
> Looking at the log I can see only queries of the type:
> TIP 5: don't forget to increase your free space map settings

Wrong list. This is one dedicated for people working on the innards of
PostgreSQL. You'd want one of  or
<[EMAIL PROTECTED]>.

Now to your question: there are many configuration parameters in the
config file (possibly in /etc/postgresql/8.2/main/postgresql.conf or
some similar location, depending on your OS and distribution) to control
the level of logging. Look there for entries named log_xxx and
debug_xxx.

HTH
- -- tomás
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGHHpCBcgs9XrR2kYRAs4SAJ45gvCVcp4Avk4t7NgQ/SST0s35owCggdWQ
CcVc9UluRe4d/Gl8ERV7z4I=
=P8EJ
-END PGP SIGNATURE-


---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[HACKERS] prepared statements logging

2007-04-10 Thread marcofuics
Hi *
I am using the postgresql-8.2.3, with a jdbc-8.2-504 (the GeoNet
webServer tool...) My question is :
Is the <> server able to log the whole <> query?
{made by a prepared statement}
Looking at the log I can see only queries of the type:

(cut).

LOG:  execute : SELECT * FROM Metadata WHERE id=$1
DETAIL:  parameters: $1 = '28'
DEBUG:  parse : 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 <> is not present!

My desire is to have a line where I can see:
SELECTbla..bla...bla   FROM   MetadataWHERE id = "...some
pattern"   [maybe islike some pattern]

Thx in advance.


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings