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