Re: [ADMIN] INITDB-error - end-of-copy marker error

JC Jan Christensen <jan(dot)christensen(at)riva-systems(dot)dk> writes:
> creating system views....ok
> loading pg_description...ERROR: end-of-copy marker does
> not match previous newline style
> CONTEXT: COPY tmp_pg_description, line 1542: ""
> initdb: failed

I was about to say I thought we'd fixed that in 7.4.2 ... but on
inspection it seems only one of the two uses of COPY got fixed :-(.
Try the attached patch.

regards, tom lane

Index: initdb.sh
===================================================================
RCS file: /cvsroot/pgsql-server/src/bin/initdb/initdb.sh,v
retrieving revision 1.204.2.1
retrieving revision 1.204.2.2
diff -c -r1.204.2.1 -r1.204.2.2
*** initdb.sh 14 Jan 2004 03:47:12 -0000 1.204.2.1
--- initdb.sh 29 Apr 2004 19:56:35 -0000 1.204.2.2
***************
*** 1043,1053 ****
classname name, \
objsubid int4, \
description text) WITHOUT OIDS;
! COPY tmp_pg_description FROM STDIN;
! EOF
! cat "$POSTGRES_DESCR"
! cat <<EOF
! \.
INSERT INTO pg_description SELECT \
t.objoid, c.oid, t.objsubid, t.description \
FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;
--- 1043,1049 ----
classname name, \
objsubid int4, \
description text) WITHOUT OIDS;
! COPY tmp_pg_description FROM '$POSTGRES_DESCR';
INSERT INTO pg_description SELECT \
t.objoid, c.oid, t.objsubid, t.description \
FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;