Re: postgres 8.2 "end-of-copy marker corrupt"
От | James Long |
---|---|
Тема | Re: postgres 8.2 "end-of-copy marker corrupt" |
Дата | |
Msg-id | 20070328220857.GA15192@ns.umpquanet.com обсуждение исходный текст |
Ответ на | Re: postgres 8.2 "end-of-copy marker corrupt" (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: postgres 8.2 "end-of-copy marker corrupt"
|
Список | pgsql-novice |
On Wed, Mar 28, 2007 at 10:15:35AM -0400, Tom Lane wrote: > "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. What is the output of: grep -c "\\\." and if that is a "small" number, the output of: grep -n "\\\." and grep "\\\." | hexdump -C
В списке pgsql-novice по дате отправления: