Re: [ADMIN] INITDB-error - end-of-copy marker error - Mailing list pgsql-cygwin

JC Jan Christensen <jan.christensen@riva-systems.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;