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





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to