Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql 7.4.1 copy - end-of-copy marker corrupt - Mailing list pgsql-general

From Tom Lane
Subject Re: pgsql 7.4.1 copy - end-of-copy marker corrupt
Date
Msg-id 24471.1076047884@sss.pgh.pa.us
Whole thread Raw
In response to pgsql 7.4.1 copy - end-of-copy marker corrupt  (Jenny Zhang <jenny@osdl.org>)
Responses Re: pgsql 7.4.1 copy - end-of-copy marker corrupt  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Jenny Zhang <jenny@osdl.org> writes:
>  ERROR:  end-of-copy marker corrupt
> CONTEXT:  COPY author, line 49: "49\aoD{\BABABABABARENG
> \t5p.\19840426"

> and this is the line in the data file it complains:
> ===
> 49\aoD{\BABABABABARENG
> \t5p.\19840426\.XfqWM+Ke,8+Ae-9PWPn)}#6eVa_Qu ...
                ^^

It doesn't like the "\.", with good reason I should think.  Are you sure
7.3 would take this file?

Anyway, either double or remove that backslash, depending on what you
want.

            regards, tom lane

pgsql-general by date:

Previous
From: "Chris Travers"
Date:
Subject: Re: Transfer database tables to a schema
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pgsql 7.4.1 copy - end-of-copy marker corrupt