pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17374: Bug in restore
2+ messages / 2 participants
[nested] [flat]
* BUG #17374: Bug in restore
@ 2022-01-20 09:25 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2022-01-20 09:25 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: riina.piiroinen@op.fi
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17374: Bug in restore
@ 2022-01-20 14:11 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2022-01-20 14:11 UTC (permalink / raw)
To: riina.piiroinen@op.fi; +Cc: pgsql-bugs@lists.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-01-20 14:11 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-01-20 09:25 BUG #17374: Bug in restore PG Bug reporting form <noreply@postgresql.org>
2022-01-20 14:11 ` Tom Lane <tgl@sss.pgh.pa.us>
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