Re: pgsql 7.4.1 copy - end-of-copy marker corrupt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jenny Zhang <jenny(at)osdl(dot)org>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgsql 7.4.1 copy - end-of-copy marker corrupt
Date: 2004-02-06 06:11:24
Message-ID: 24471.1076047884@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jenny Zhang <jenny(at)osdl(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-02-06 06:52:10 Re: pgsql 7.4.1 copy - end-of-copy marker corrupt
Previous Message Chris Travers 2004-02-06 03:23:18 Re: Transfer database tables to a schema