BUG #14088: pg_restore, --schema, causes TOC entries from even executing. - Mailing list pgsql-bugs

From psi-jack@linux-help.org
Subject BUG #14088: pg_restore, --schema, causes TOC entries from even executing.
Date
Msg-id 20160415191246.22924.68401@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14088: pg_restore, --schema, causes TOC entries from even executing.
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14088
Logged by:          Eric Renfro
Email address:      psi-jack@linux-help.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.

pgsql-bugs by date:

Previous
From: joris.vandyck@promani.be
Date:
Subject: BUG #14087: btree_gin index doesn't work on INT with POSITIVE constraint
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14088: pg_restore, --schema, causes TOC entries from even executing.