Randall Wilson <rwilson(at)earthcomber(dot)com> 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
> causing the error? I thought the "Idle" error was caused by errors found
> during background processes, like vacuums.
You'd have to tell us what your log_line_prefix is before we could
interpret that, but yeah, an encoding error in an incoming query string
would be reported before the backend could even consider going non-idle.
A SQL_ASCII database would have accepted any data whatsoever. If you
want to change to something where you actually know the encoding, that's
fine, but realize that you're going to have to make your clients be
honest about what encoding they're using, too.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2008-09-18 21:01:33|
|Subject: Re: type unknown? |
|Previous:||From: Carol Walter||Date: 2008-09-18 20:29:03|
|Subject: type unknown?|