Re: Getting "insufficient data left in message" on copy with binary - Mailing list pgsql-general

Gordon Shannon <gordo169@gmail.com> writes:
> I'm running 8.4 on Linux/Centos.  I am doing a "copy (select ....) to
> '/absolute/path/to/file.dat' with binary". That works fine.  But when I load
> that file into a table...

>   copy mytable (id, mlid, parent_mlid, author_id, date_id, time_id,
> content_type_id, provider_id,
>     is_duplicate, is_spam, language_code, profanity, tonality, sentiment,
> created_time, updated_at)
>   from '/absolute/path/to/file.dat' with binary;

>   ERROR:  insufficient data left in message
>   CONTEXT:  COPY mytable, line 1, column provider_id

> Anybody seen this?

No.  Can you extract a self-contained test case?

            regards, tom lane