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

From Jenny Zhang
Subject pgsql 7.4.1 copy - end-of-copy marker corrupt
Date
Msg-id 1076032173.32703.89.camel@ibm-a.pdx.osdl.net
Whole thread Raw
Responses Re: pgsql 7.4.1 copy - end-of-copy marker corrupt  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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[@-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


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Sort order confusion
Next
From: Tom Lane
Date:
Subject: Re: Sort order confusion