Today while trying to do a bulk COPY of data into a table, the process
aborted with the following error message:

ERROR: end-of-copy marker corrupt
CONTEXT: COPY tbl_logged_event, line 178519: "606447014,1492,2005-02-24
03:16:14,2005-02-23 20:27:48,win_applog,,error,adsmclientservice,nt

Googling the error, we found reference to the '\.' (backslash-period) being
an "end-of-copy marker".  Unfortunately, our data contains the
backslash-period character sequence.  Is there any know fix or workaround
for this condition?

We're using Postgresql 7.3.9 and also running tests on an 8.0.1 system.

Thanks in advance,
--- Steve

Steven Rosenstein
IT Architect/Developer | IBM Virtual Server Administration
Voice/FAX: 845-689-2064 | Cell: 646-345-6978 | Tieline: 930-6001
Text Messaging: 6463456978 @
Email: srosenst @

"Learn from the mistakes of others because you can't live long enough to
make them all yourself." -- Eleanor Roosevelt

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to