From: Tom Lane <tgl@sss.pgh.pa.us>
To: riina.piiroinen@op.fi
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17374: Bug in restore
Date: Thu, 20 Jan 2022 09:11:12 -0500
Message-ID: <856627.1642687872@sss.pgh.pa.us> (raw)
In-Reply-To: <17374-33152d4618de991f@postgresql.org>
References: <17374-33152d4618de991f@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, riina.piiroinen@op.fi, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17374: Bug in restore
In-Reply-To: <856627.1642687872@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox