Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension
Date
Msg-id 19310.1484256476@sss.pgh.pa.us
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension
Next
From: Jonathon Nelson
Date:
Subject: Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?