BUG #14088: pg_restore, --schema, causes TOC entries from even executing.

From: psi-jack(at)linux-help(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14088: pg_restore, --schema, causes TOC entries from even executing.
Date: 2016-04-15 19:12:46
Message-ID: 20160415191246.22924.68401@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14088
Logged by: Eric Renfro
Email address: psi-jack(at)linux-help(dot)org
PostgreSQL version: 9.4.5
Operating system: CentOS 6
Description:

I found a bug when trying to backup, stripping BDR schemas from databases to
restore to a non-BDR database, and this is a pretty serious bug.

When using pg_restore -l --schema=public with pg_restore -L from that data,
the -l does not contain information needed for the --create flag to work.
For example, DATABASE TOC entries are missing from the -l output.

Likewise, when using pg_restore --schema=public --create, again, key TOC
entries related to creation fail to exist because --schema is being used.

This resulted in all create items not restoring with the --create flag used.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-04-15 20:54:21 Re: BUG #14088: pg_restore, --schema, causes TOC entries from even executing.
Previous Message joris.vandyck 2016-04-15 18:59:02 BUG #14087: btree_gin index doesn't work on INT with POSITIVE constraint