Обсуждение: BUG #17374: Bug in restore

The following bug has been logged on the website:

Bug reference:      17374
Logged by:          Riina Piiroinen
Email address:      riina.piiroinen@op.fi
PostgreSQL version: Unsupported/Unknown
Operating system:   Desktop App
Description:

While restoring backup-file to another schema, I got following error:
"pg_restore: could not execute query: ERROR  "<table_name>" already
exists.
 
Despite the error, the rows in the tables doubled.

I use Desktop version, and version is 5.6.

PG Bug reporting form <noreply@postgresql.org> writes:
> While restoring backup-file to another schema, I got following error:
> "pg_restore: could not execute query: ERROR  "<table_name>" already
> exists.
> Despite the error, the rows in the tables doubled.

That sounds like the expected result if you try to restore over
an existing table.  Use --clean to drop and recreate the target
tables.

            regards, tom lane