From: | "A(dot) Van Hook" <hook(at)kcp(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | (no subject) |
Date: | 2003-08-07 10:14:16 |
Message-ID: | 3F322678.5070908@kcp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)kcp(dot)com (816)997-3531
hook(at)lota(dot)us (816)578-4704
hook(at)lake-lotawana(dot)mo(dot)us (816)578-4215
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-07 15:10:32 | Re: (no subject) |
Previous Message | Martijn van Oosterhout | 2003-08-07 09:30:07 | Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram |