Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 8.2 "end-of-copy marker corrupt" - Mailing list pgsql-novice

From Tom Lane
Subject Re: postgres 8.2 "end-of-copy marker corrupt"
Date
Msg-id 12159.1174972727@sss.pgh.pa.us
Whole thread Raw
In response to postgres 8.2 "end-of-copy marker corrupt"  ("David Monarchi" <david.e.monarchi@gmail.com>)
Responses Re: postgres 8.2 "end-of-copy marker corrupt"  ("David Monarchi" <david.e.monarchi@gmail.com>)
List pgsql-novice
Tree view 
"David Monarchi" <david.e.monarchi@gmail.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

pgsql-novice by date:

Previous
From: "David Monarchi"
Date:
Subject: postgres 8.2 "end-of-copy marker corrupt"
Next
From: "mary"
Date:
Subject: Novice Install