Re: error messages during restore

Tom Lane wrote:
> Geoffrey Myers <lists(at)serioustechnology(dot)com> writes:
>> So we are in the process of converting our databases from SQL_ASCII to
>> UTF8. If a particular row won't import because of the encoding issue we
>> get an error like:
>
>> pg_restore: [archiver (db)] Error from TOC entry 5317; 0 1266711 TABLE
>> DATA logs postgres
>> pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
>> for encoding "UTF8": 0x90
>> HINT: This error can also happen if the byte sequence does not match
>> the encoding expected by the server, which is controlled by
>> "client_encoding".
>> CONTEXT: COPY logs, line 590744
>
>> Question is, it would be really nice if we could figure out the actual
>> column name in that table.
>
> Sorry, no chance of that. The line is converted to server encoding
> before any attempt is made to split it into columns. Since the column
> delimiter is potentially encoding-specific, there's not really any
> alternative to doing it that way.
>
> regards, tom lane

Thanks for the follow up Tom.

--
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson