Corrupted end of Record

Started by Herb Blackerover 24 years ago2 messagesgeneral
Jump to latest
#1Herb Blacker
herbblacker@isgenesis.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Herb Blacker (#1)
Re: Corrupted end of Record

"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