From: | Janning Vygen <vygen(at)kicktipp(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem with invalid byte sequence and log_min_error_statement |
Date: | 2009-04-15 15:31:45 |
Message-ID: | 200904151731.45893.vygen@kicktipp.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
i run the greatest database ever, postgresql-8.3, on debian etch
I am investigating some error messages in my log file:
Apr 15 08:04:34 postgres[20686]: [4-1] 2009-04-15 08:04:34 CEST ERROR:
invalid byte sequence for encoding "UTF8": 0x81
Apr 15 08:04:34 postgres[20686]: [4-2] 2009-04-15 08:04:34 CEST HINT: This
error can also happen if the byte sequence does not match the encoding
expected by the
Apr 15 08:04:34 postgres[20686]: [4-3] server, which is controlled by
"client_encoding".
I want to know which statement produces this error. I have
show log_min_error_statement ;
error
show log_error_verbosity;
default
so i think the error statement should be logged. Why is the error statement
not logged? Or do i need to set log_error_verbosity to verbose to see the
statement producing the error?
I always see 0x81 and 0xe46973 as invalid byte sequence. Can someone give me a
hint what characters in which encoding those bytes might be?
kind regards
Janning
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-04-15 15:33:01 | Re: Performance of full outer join in 8.3 |
Previous Message | Albe Laurenz | 2009-04-15 15:15:43 | Re: need information |