Gordon Shannon <gordo169(at)gmail(dot)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