Thread

1. Function COPY

   DaviS Quirico <davis@davisnet.it> — 2000-11-20T15:53:15Z

   Hi,
   I use postgresql 7.0.3 in redhat 6.2.
   I installed .rpm binary and work good.
   But i find a problem during import text file
   Using the function copy from a text file (about 250Mb of size) i can see
   this error:
   
   CopyReadAttribute: end of record marker corrupted
   
   So, i can't import my data.
   
   I try using small file, nothing to do..
   
   I try with the "original" 6.5.3 in bundle with RH 6.2 and i get the same
   result...
   
   Any ideas?
   
   Thanks.
   
   
   
   
   

2. Re: Function COPY

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-11-24T01:52:20Z

   "DaviS Quirico" <davis@davisnet.it> writes:
   > CopyReadAttribute: end of record marker corrupted
   
   This message comes out if the COPY data contains \. not immediately
   followed by newline (\n).  I'm guessing that you have some backslashes
   that need to be doubled --- backslash is an escape character for COPY.
   
   Another possibility is that you actually did put a \. end-marker after
   your data, but followed it with a DOS-style return (\r\n) or nothing at
   all.
   
   			regards, tom lane