Thread: 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