Re: [SQL] error: lost syncronization with server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jeff Lu" <jklcom(at)mindspring(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] error: lost syncronization with server
Date: 2003-04-02 15:35:23
Message-ID: 21211.1049297723@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

"Jeff Lu" <jklcom(at)mindspring(dot)com> writes:
> ERROR: copy: line 1, CopyReadAttribute: end of record marker
> corrupted

I'd wonder if you did something to the dump file that caused newlines to
get converted from \n to \r\n, or some such. COPY isn't real forgiving
about that ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-02 15:36:35 Re: Forcing use of indexes
Previous Message Teodor Sigaev 2003-04-02 15:21:49 Re: Problem installing tsearch V2 on a FreeBSD

Browse pgsql-sql by date

  From Date Subject
Next Message Walter McGinnis 2003-04-02 17:35:54 Re: pesky plpgsql
Previous Message Jeff Lu 2003-04-02 15:19:25 error: lost syncronization with server