Re: Function COPY

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "DaviS Quirico" <davis(at)davisnet(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Function COPY
Date: 2000-11-24 01:52:20
Message-ID: 8188.975030740@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"DaviS Quirico" <davis(at)davisnet(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2000-11-24 14:17:09 Bug in select with 'like' and index of two columns
Previous Message Tom Lane 2000-11-24 01:46:52 Re: Comparison of Strings