(no subject)

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

Responses

Browse pgsql-sql by date

  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