Re: BUG #7873: pg_restore --clean tries to drop tables that don't exist

On Wed, Feb 13, 2013 at 08:22:43PM +0000, autarch(at)urth(dot)org wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7873
> Logged by: Dave Rolsky
> Email address: autarch(at)urth(dot)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.

Well, I think the question is whether you want error feedback for things
that don't exist. I don't really know the answer.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +