pgsql 7.4.1 copy - end-of-copy marker corrupt

From: Jenny Zhang <jenny(at)osdl(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pgsql 7.4.1 copy - end-of-copy marker corrupt
Date: 2004-02-06 01:49:34
Message-ID: 1076032173.32703.89.camel@ibm-a.pdx.osdl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just upgraded to 7.4.1. I was loading my database using 'copy'. Some
tables loaded with no problem, while some gave me the error:
===
ERROR: end-of-copy marker corrupt
CONTEXT: COPY author, line 49: "49\aoD{\BABABABABARENG
\t5p.\19840426"
===

This is the load script:
===
\set AUTOCOMMIT off
COPY author FROM '/tmp/author.data' USING DELIMITERS '\\';
commit;

and this is the line in the data file it complains:
===
49\aoD{\BABABABABARENG
\t5p.\19840426\.XfqWM+Ke,8+Ae-9PWPn)}#6eVa_QuNi*%{Y[?ip]Gx]6i-H[W&8K$dp/}uk57Dl6].*IdV 5(Lxl?4bS5~yhyY18(WcoZ fl,Lutg^Ok[(at)-H0hvU2J1lhReln7}/|qjH1O0T: }D!,Lvc6^PAg04);Es=Op~4{FrX|.PM_T+ 03xVi#s bL(VPZczAbTJg.ht]w6.A%Q0g%H pz~*!CXKb-9xLN7%eDWqzN7=]{lt1ssbG$HB^0hblc}(pvvFyDv

I think this is strange since I've loaded the tables with the same
datafile and same command (except for the autocommit part) in 7.3.3 with
no problem. Even in 7.4.1, I have some tables loaded successfully.

Can someone tell me what I did wrong or copy is buggy?

Thanks,
Jenny

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-06 02:08:14 Re: Sort order confusion
Previous Message Stephan Szabo 2004-02-06 01:16:22 Re: Sort order confusion