Re: Statements with syntax errors are not logged

From: tomas(at)tuxteam(dot)de
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Statements with syntax errors are not logged
Date: 2006-10-19 15:18:44
Message-ID: 20061019151844.GA7346@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Oct 19, 2006 at 04:28:17PM +0200, Peter Eisentraut wrote:
> When setting log_statement = 'all', statements that fail parsing are not
> logged. For example:

[...]

HA! This one has bitten me just today :-)

The problem was a faulty client sending garbage and PostgreSQL
complaining (rightfully) about bad UTF-8.

But I quicly understood the problem and managed to debug otherwise (the
raised eyebrows didn't last for long ;-)

So I don't know whether it's worth to add complexity for this.

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

iD8DBQFFN5dUBcgs9XrR2kYRAqITAJ4sRSqDS0vkn56UeODJlLEZWgugiwCfY8vO
H70VJ3XRbl9PME1s8HRefHA=
=JcT2
-----END PGP SIGNATURE-----

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-10-19 15:33:17 Re: Statements with syntax errors are not logged
Previous Message Jim C. Nasby 2006-10-19 15:08:38 Re: Additional stats for Relations