From: | Steven Rosenstein <srosenst(at)us(dot)ibm(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Bulk COPY end of copy delimiter |
Date: | 2005-04-04 23:40:30 |
Message-ID: | OF93689C76.0D3B597A-ON85256FD9.0081921E-85256FD9.00820D37@us.ibm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
author..."
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 @ mobile.mycingular.com
Email: srosenst @ us.ibm.com
"Learn from the mistakes of others because you can't live long enough to
make them all yourself." -- Eleanor Roosevelt
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2005-04-05 00:00:15 | Re: Bulk COPY end of copy delimiter |
Previous Message | Mike Rylander | 2005-04-04 23:28:25 | Re: Sustained inserts per sec ... ? |