The following bug has been logged online: Bug reference: 4054 Logged by: Martin Gregorie Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux (Redhat Fedora 8 Description: Text containing ';' upsets db restores Details:
I've been dumping my database using pg_dumpall in its default (fast) version. This weekend, after upgrading from Fedora 7 to Fedora 8 I had to restore my database. Finger trouble & tiredness caused the restore. The database survived the upgrade but not me. I found that replaying the output from pg_dumpall into psql caused problems: 1) A VIEW in the database was not dropped. The DROP for it was not in the pg_dumpall file). Minor point, mentioned only for completeness. A manual DROP fixed that. 2) Every table has an int as the first field. This number value is flagged as an error for the first row in every table. 3) My tables have BYTEA and TEXT fields in them. In some rows these field contain HTML text. This caused syntax errors during the reload. Specifically, "; " and "</" sequences were interpreted by psql as syntactic errors wherever they occur in textual fields. 4) I was running psql with a -1 option which, rather to my surprise, didn't abort the run after the first error in the file. Lines that are not flagged with errors seem to have loaded OK The pg_dumpall that made the dumps was from the fully patched version of Fedora 7 (Postgresql 8.2.5?). The restore was made using psql from version 8.2.6. The errors were captured in the log file, which is safe from being overwritten. You're welcome to either the whole thing or to edited highlights from it. - Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
