X-Original-To: pgsql-general@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id CD316474E44; Wed,  2 Apr 2003 10:35:52 -0500 (EST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by postgresql.org (Postfix) with ESMTP
	id 978BC474E44; Wed,  2 Apr 2003 10:35:21 -0500 (EST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h32FZN2L021212;
	Wed, 2 Apr 2003 10:35:24 -0500 (EST)
To: "Jeff Lu" <jklcom@mindspring.com>
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] error: lost syncronization with server 
In-reply-to: <01c901c2f92b$3fa43030$1501a8c0@DemoServer> 
References: <01c901c2f92b$3fa43030$1501a8c0@DemoServer>
Comments: In-reply-to "Jeff Lu" <jklcom@mindspring.com>
	message dated "Wed, 02 Apr 2003 10:19:25 -0500"
Date: Wed, 02 Apr 2003 10:35:23 -0500
Message-ID: <21211.1049297723@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Spam-Status: No, hits=-32.5 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/85
X-Sequence-Number: 40150

"Jeff Lu" <jklcom@mindspring.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