Re: BUG #4281: some types of errors do not log statements - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #4281: some types of errors do not log statements
Date
Msg-id 200808221749.m7MHnuU27465@momjian.us
Whole thread Raw
In response to BUG #4281: some types of errors do not log statements  ("thomas" <me@alternize.com>)
Responses Re: BUG #4281: some types of errors do not log statements
Re: BUG #4281: some types of errors do not log statements
List pgsql-bugs
thomas wrote:
>
> The following bug has been logged online:
>
> Bug reference:      4281
> Logged by:          thomas
> Email address:      me@alternize.com
> PostgreSQL version: 8.3.3
> Operating system:   Windows 2003
> Description:        some types of errors do not log statements
> Details:
>
> this isn't really a bug but rather a request for an improvement.
>
> i've noticed that in some cases of errornous sql statements, the statement
> itself is logged to the pg_log, in other cases it isn't:
>
> logged:
>
> 2008-07-05 01:53:02 CEST 3528 486eade5.dc8 10.1.1.71(53082)ERROR:  column
> "xyz" does not exist at character 294
> 2008-07-05 01:53:02 CEST 3528 486eade5.dc8 10.1.1.71(53082)STATEMENT:
> SELECT xyz FROM test
>
>
> not logged:
>
> 2008-07-05 02:16:15 CEST 6644 486ebab4.19f4 127.0.0.1(1616)ERROR:  invalid
> byte sequence for encoding "UTF8": 0xc474
> 2008-07-05 02:16:15 CEST 6644 486ebab4.19f4 127.0.0.1(1616)HINT:  This error
> can also happen if the byte sequence does not match the encoding expected by
> the server, which is controlled by "client_encoding".
>
>
> it would be usefull to always see the sql statement that provoked the error.
> especially in the case of wrong utf byte sequences it can get very difficult
> to find the point of failure without more information.

I am unclear what would cause this.  Is the STATEMENT: line coming from
log_statement?  What is the query that is not showing?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #4274: uuid returns duplicate values
Next
From: "Eric P. Melbardis"
Date:
Subject: Re: BUG #4274: uuid returns duplicate values