[HACKERS] pg_dump restore error

2012-10-14 Thread Gilles Darold
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

Re: [HACKERS] pg_dump restore error

2012-10-14 Thread Tom Lane
Gilles Darold gilles.dar...@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

Re: [HACKERS] pg_dump restore error

2012-10-14 Thread Gilles Darold
Le 14/10/2012 18:50, Tom Lane a écrit : Gilles Darold gilles.dar...@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