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"  ("David Monarchi" <david.e.monarchi@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Lenorovitz, Joel"
Дата:
Сообщение: Re: ER diagrams
Следующее
От: Noel Faux
Дата:
Сообщение: Re: ER diagrams