(no subject)
От | A. Van Hook |
---|---|
Тема | (no subject) |
Дата | |
Msg-id | 3F322678.5070908@kcp.com обсуждение исходный текст |
Ответы |
Re: (no subject)
|
Список | 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@kcp.com (816)997-3531 hook@lota.us (816)578-4704 hook@lake-lotawana.mo.us (816)578-4215
В списке pgsql-sql по дате отправления: