Thread: Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Tom Lane wrote:
>> Moshe Jacobson <moshe@neadwerx.com> writes:
>>> The reason I add the dynamically-created tables to the extension is so that
>>> they are never included in the pg_dump output.

>> The extension mechanism definitely isn't meant to do that ;-).  Maybe
>> you could put these not-to-dump tables in their own schema and exclude
>> that schema from pg_dump with -N?

> Is this related to this commit?
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f2fcad27d59c8e5c48f8fa0a96c8355e40f24273

Seems like it doesn't quite match Moshe's use case --- he *doesn't* want
those tables dumped.  I'm not sure if he cares whether they have
dependencies on the extension.

            regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs