pg_dump restore error
Gilles Darold <gilles.darold@dalibo.com>
From: Gilles Darold <gilles.darold@dalibo.com>
To: pgsql-hackers@postgresql.org
Date: 2012-10-14T14:47:40Z
Lists: pgsql-hackers
Attachments
- pg_dump-drop_if_exists-patch.diff (text/x-patch) patch
Hello, Restoring a backup generated with pg_dump/pg_dumpall in plain text format and the --clean option will report errors if the backup is loaded in an other or empty database. I mean that the backup file contains all SQL order to drop the database's objects before recreating them, so if you load this backup into a new database it will throw errors on each DROP call complaining that the objects doesn't exists. This is not very important because everything goes fine but these error reports can be easily prevented with the addition of IF EXISTS clauses and this will probably be less confusing. I've attached a patch adding those IF EXISTS on each DROP and ALTER statements. Best regards, -- Gilles Darold http://dalibo.com - http://dalibo.org