Re: pg_dump restore error

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gilles Darold <gilles.darold@dalibo.com>
Cc: pgsql-hackers@postgresql.org
Date: 2012-10-14T16:50:44Z
Lists: pgsql-hackers
Gilles Darold <gilles.darold@dalibo.com> writes:
> 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.

This is intentional.  What you propose amounts to a fundamental change
in the semantics of --clean, and I don't think that it's really much
of an improvement.

			regards, tom lane