Thomas Burns wrote:
> I ran into a problem while restore a database. I am converting a
> database from SQLASCII to UTF8. The pg_restore fails with:
>
> pg_restore: ERROR: invalid UTF-8 byte sequence detected near byte
> 0xe7 CONTEXT: COPY sl_email_messages, line 119593, column message:
> "In Reply To:get a life
>
> and terminates. What I would like to happen is for pg_restore to
> ignore this error and continue on. Is there a way to make it do
> that?
No, you have to find out which encoding that actually is and then set
your client encoding to that when restoring.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/