Skip site navigation (1) Skip section navigation (2)

Re: Idle Error invalid byte sequence

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Randall Wilson <rwilson(at)earthcomber(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Idle Error invalid byte sequence
Date: 2008-09-18 20:57:30
Message-ID: 2079.1221771450@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-09-18 21:01:33
Subject: Re: type unknown?
Previous:From: Carol WalterDate: 2008-09-18 20:29:03
Subject: type unknown?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group