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 B1266D1C7F8 for ; Thu, 7 Aug 2003 10:15:27 +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 58845-05 for ; Thu, 7 Aug 2003 07:14:05 -0300 (ADT) Received: from snoopy.os.kcp.com (snoopy.os.kcp.com [198.124.201.8]) by svr1.postgresql.org (Postfix) with ESMTP id 3BB85D1C941 for ; Thu, 7 Aug 2003 07:15:16 -0300 (ADT) Received: from kcpgw3.kcp.com (kcpgw3 [198.62.69.70]) by snoopy.os.kcp.com (8.12.9/8.12.7) with SMTP id h77AENKv016018 for ; Thu, 7 Aug 2003 05:14:23 -0500 (CDT) Received: from bagman.kcp.com by kcpgw3.kcp.com via smtpd (for snoopy.os.kcp.com [198.124.201.8]) with SMTP; 7 Aug 2003 10:14:23 UT Received: from mailhub.kcp.com (unverified) by bagman.kcp.com (Content Technologies SMTPRS 4.2.5) with ESMTP id for ; Thu, 7 Aug 2003 05:14:17 -0500 Received: from kcp.com (f5-vip.kcp.com [147.101.224.112]) by mailhub.kcp.com (8.12.8/8.12.8) with ESMTP id h77AEKSL026980 for ; Thu, 7 Aug 2003 05:14:21 -0500 (CDT) Message-ID: <3F322678.5070908@kcp.com> Date: Thu, 07 Aug 2003 05:14:16 -0500 From: "A. Van Hook" User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: (no subject) Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/63 X-Sequence-Number: 14679 We have been using 7.3.3 on several different applications and have discovered an anomaly. Backups are done nightly using "pg_dump --attribute-inserts -f att.dump.`dcode` spdb"; 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. i.e. INSERT INTO registry (rid, sid, aflag, fname, lname, mi, addr, city, state, zip, phone, email, weddate, regdate, items, \ notes, ref) VALUES (1148, 503, NULL, 'Jillian', 'Kooker', ' ', '', '', '', '', '610-649-3327', '', '2002-10-24', '2002-0\ 8-15', 'HP: 9120 Malis Henderson Veil: S2378 sparkle tulle and rat-tail edge', 'Used an 888 slip^M <<<<<< What am I doing wrong?? thanks -- A. R. Van Hook Honeywell Federal Manufacturing & Technologies IT System Engineer City of Lake Lotawana MO Mayor pager (816)458-2585 cell (816)564-0769 hook@kcp.com (816)997-3531 hook@lota.us (816)578-4704 hook@lake-lotawana.mo.us (816)578-4215