From: A. Van Hook <hook@kcp.com>
To: pgsql-sql@postgresql.org
Subject: (no subject)
Date: Thu, 07 Aug 2003 05:14:16 -0500
Message-ID: <3F322678.5070908@kcp.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hook@kcp.com
Subject: Re: (no subject)
In-Reply-To: <3F322678.5070908@kcp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox