Re: postgres 8.2 "end-of-copy marker corrupt"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres 8.2 "end-of-copy marker corrupt"
Date: 2007-03-27 05:18:47
Message-ID: 12159.1174972727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com> writes:
> I'm trying to copy a file to a table in Postgres 8.2 and keep receiving the
> following message

> ERROR: end-of-copy marker corrupt
> CONTEXT: COPY domain_dom, line 3147756: ""

Have you looked at the input file near that line number? My guess is
misquoting of a \. sequence, or possibly (since you seem to be on
Windows) a LF-vs-CR/LF end-of-line format issue. It need not be
close to the actual end of that file...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message mary 2007-03-27 05:47:40 Novice Install
Previous Message David Monarchi 2007-03-27 04:33:58 postgres 8.2 "end-of-copy marker corrupt"