From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Moshe Jacobson <moshe(at)neadwerx(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, daniele(dot)varrazzo(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension |
Date: | 2017-01-12 21:00:11 |
Message-ID: | 18075.1484254811@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Moshe Jacobson <moshe(at)neadwerx(dot)com> writes:
> On Thu, Jan 12, 2017 at 2:01 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> I think this scenario is simply pilot error, or at least gross abuse of
>> the extension system. If you dump and reload a DB containing an extension,
>> the extension definition that's fetched by CREATE EXTENSION is expected
>> to define (at least) all the objects that belonged to the extension in the
>> old DB. You can't just randomly ALTER EXTENSION and not update the
>> extension definition script to match.
> The reason I add the dynamically-created tables to the extension is so that
> they are never included in the pg_dump output. If this is a gross abuse of
> the extension system, is there another way you can suggest to mark these
> tables as not-to-be-dumped?
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?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2017-01-12 21:22:08 | Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension |
Previous Message | Moshe Jacobson | 2017-01-12 19:34:26 | Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension |