pgsql 7.4.1 copy - end-of-copy marker corrupt
От | Jenny Zhang |
---|---|
Тема | pgsql 7.4.1 copy - end-of-copy marker corrupt |
Дата | |
Msg-id | 1076032173.32703.89.camel@ibm-a.pdx.osdl.net обсуждение исходный текст |
Ответы |
Re: pgsql 7.4.1 copy - end-of-copy marker corrupt
|
Список | 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 по дате отправления: