Postgres Pro
Downloads
Home   >   mailing lists

Thread: Corrupted end of Record

Corrupted end of Record

From
"Herb Blacker"
Date:
When attempting to load in (via COPY) two files of ~700 and ~12,000 records,
I get the following:

ERROR:  copy: line 694, CopyReadAttribute: end of record marker corrupted

ERROR:  copy: line 11987, CopyReadAttribute: end of record marker corrupted

This is the line that COPY requires at the end of the file (i.e. backslash
period - \.)

If I remove the line, the load works fine.
I have loaded other files using the same last line and they work fine...

Any ideas?

TIA,
Herb Blacker

Re: Corrupted end of Record

From
Tom Lane
Date:
"Herb Blacker" <herbblacker@isgenesis.com> writes:
> ERROR:  copy: line 694, CopyReadAttribute: end of record marker corrupted

Check to see if your file contains DOS-style newlines (CR/LF instead of
just LF).  COPY is not forgiving about that.

            regards, tom lane