BUG #7873: pg_restore --clean tries to drop tables that don't exist
Dave Rolsky <autarch@urth.org>
From: autarch@urth.org
To: pgsql-bugs@postgresql.org
Date: 2013-02-13T20:22:43Z
Lists: pgsql-bugs, pgsql-hackers
The following bug has been logged on the website: Bug reference: 7873 Logged by: Dave Rolsky Email address: autarch@urth.org PostgreSQL version: 9.2.3 Operating system: Linux Description: When you pass the --clean option to pg_restore it tries to drop tables without checking if they exist. This results in lots of error output. If you're running pg_restore via an automated process it's very hard to distinguish between these "ok" errors and real errors. It should be using "DROP TABLE IF EXISTS" and the equivalent for constraints.