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