Thread: prepared statements logging

prepared statements logging

From
"marcofuics"
Date:
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.



Re: prepared statements logging

From
tomas@tuxteam.de
Date:
-----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 <<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:
> 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 <pgsql-admin@postgresql.org> or
<pgsql-novice@postgresql.org>.

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-----