Bulk COPY end of copy delimiter
От | Steven Rosenstein |
---|---|
Тема | Bulk COPY end of copy delimiter |
Дата | |
Msg-id | OF93689C76.0D3B597A-ON85256FD9.0081921E-85256FD9.00820D37@us.ibm.com обсуждение исходный текст |
Ответы |
Re: Bulk COPY end of copy delimiter
|
Список | 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
В списке pgsql-performance по дате отправления: