Re: [ADMIN] Idle Error invalid byte sequence

2008-09-18 Thread Randall Wilson
a reply. Thanks again, Randy Wilson Tom Lane wrote: > Randall Wilson <[EMAIL PROTECTED]> writes: > >> Yes, the encoding was changed from SQL_ASCII to UTF-8. Does the fact >> that it's an "Idle" error conform your theory that some client is >> cau

Re: [ADMIN] Idle Error invalid byte sequence

2008-09-18 Thread Randall Wilson
n text backup of the live database and I'm not having any luck grepping for the character. I may be doing it wrong. If I can't find it in the database dump, what does that tell us? Is it possibly in a template database. Thanks for your help, Randy Tom Lane wrote: > Randall Wilson <[EMAI

[ADMIN] Idle Error invalid byte sequence

2008-09-18 Thread Randall Wilson
Hi all, We've got a PostgreSQL 8.1.11 database that started displaying these error messages almost immediately AFTER it was restored. It restored fully and successfully. They occur every few seconds to every few minutes. Here are the error messages. [2008-09-18 10:18:14 CDT] idleERROR: invalid by