Re: Bug? was: Re: ERROR: could not convert UTF8 character to ISO8859-1

JP Glutting <jpglutting@oqua.udl.es> writes:
> This is reproducible, and I think it is a bug, because I have the
> problem not only with data backed up from Postgres 8.0 and restored to
> Postgres 8.1, but with data generated in Postgres 8.1. It is
> reproducible, at least on Windows XP. Here is a table that I backed up
> from Postgres 8.0. It can be restored into a Postgres 8.0 or 8.1
> database, but it cannot then be backed up in Postgres 8.1.

The error message seems perfectly clear to me: you've got a character in
that table that has no representation in LATIN1.  The difference between
8.0 and 8.1 behavior is probably because you're somehow using different
client_encoding settings in the two cases.

            regards, tom lane