Re: pg_dumping extensions having sequences with 9.6beta3 - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_dumping extensions having sequences with 9.6beta3
Date
Msg-id CAB7nPqSQ=c79_Bh9-Y=ntBm3WA_5cdHqvAKxzYJdZVZ32TK+Fw@mail.gmail.com
Whole thread Raw
In response to Re: pg_dumping extensions having sequences with 9.6beta3  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_dumping extensions having sequences with 9.6beta3
List pgsql-hackers
On Sat, Jul 30, 2016 at 5:47 AM, Stephen Frost <sfrost@snowman.net> wrote:
> What we need to be doing here is combining the set of components that
> the sequence has been marked with and the set of components that the
> table has been marked with, not trying to figure out if the sequence is
> a member of an extension or not and changing what to do in those cases,
> that's checkExtensionMembership()'s job, really.

OK, thanks for the confirmation. I have been playing a bit with your
patch and it is correctly dumping ACLs and policies that are modified
after creating an extension. So that looks good to me.

> Attached is a patch implementing this and which passes the regression
> tests you added and a couple that I added for the non-extension case.
> I'm going to look at adding a few more regression tests and if I don't
> come across any issues then I'll likely push the fix sometime tomorrow.

+        * table will be equivilantly marked.
s/equivilantly/equivalently/.

By the way, I noticed 3 places in dumpProcLang and 1 place in
dumpSequence where dobj.dump is used in a test but it is not directly
compared with DUMP_COMPONENT_NONE. Perhaps you'd want to change that
as well..
-- 
Michael



pgsql-hackers by date:

Previous
From: Andrew Borodin
Date:
Subject: Re: Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC]
Next
From: Amit Kapila
Date:
Subject: Re: old_snapshot_threshold allows heap:toast disagreement