X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id D9176D1C4EC for ; Thu, 7 Aug 2003 15:11:01 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 92196-02 for ; Thu, 7 Aug 2003 12:09:36 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id CE685D1C4DB for ; Thu, 7 Aug 2003 12:10:50 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h77FAWSa015672; Thu, 7 Aug 2003 11:10:33 -0400 (EDT) To: "A. Van Hook" Cc: pgsql-sql@postgresql.org Subject: Re: (no subject) In-reply-to: <3F322678.5070908@kcp.com> References: <3F322678.5070908@kcp.com> Comments: In-reply-to "A. Van Hook" message dated "Thu, 07 Aug 2003 05:14:16 -0500" Date: Thu, 07 Aug 2003 11:10:32 -0400 Message-ID: <15671.1060269032@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/65 X-Sequence-Number: 14681 "A. Van Hook" writes: > Dump files are used to restore and test. This test method has been used > successfully on > all previous versions. However, in 7.3.3, when the dump utility hits a > carriage return imbeded with in a text field, the > dump utility immeadiately jumps to the next record rendering the dump of > successive records useless. AFAICT, pg_dump with -D in 7.3 and current dumps embedded carriage returns and newlines literally, same as it always has. I suspect your problems are not actually with Postgres, but with some other tool that is misreading or altering the dump file. Personally, I would use pg_dump without -D. Recent versions give a fairly nice behavior for embedded control characters: COPY foo (f1) FROM stdin; aaa\rbbb\r\nccc aaa\rbbb\r\nccc \. regards, tom lane