Re: postgres 8.2 "end-of-copy marker corrupt"
От | Tom Lane |
---|---|
Тема | Re: postgres 8.2 "end-of-copy marker corrupt" |
Дата | |
Msg-id | 24203.1175091335@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: postgres 8.2 "end-of-copy marker corrupt" ("David Monarchi" <david.e.monarchi@gmail.com>) |
Ответы |
Re: postgres 8.2 "end-of-copy marker corrupt"
|
Список | pgsql-novice |
"David Monarchi" <david.e.monarchi@gmail.com> writes: > Each line is terminated with a LF (0A), including the last line. This is > the structure that of all of the other files that I can load have. > Some of the text fields in the file had \ in them, so I simply replaced all > of them with blanks to see if somewhere there was an escape sequence that > was causing the problem. Hm ... AFAICS from looking at the code, it's impossible to get that error message unless the file contains \ followed by . followed by something that's not either CR or LF. Are you sure you changed all the \ characters? Are you using CSV mode or traditional COPY format? What's the setting of client_encoding? regards, tom lane
В списке pgsql-novice по дате отправления: