Re: pg_dumping extensions having sequences with 9.6beta3

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Noah Misch <noah(at)leadboat(dot)com>, Philippe BEAUDOIN <phb(dot)emaj(at)free(dot)fr>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dumping extensions having sequences with 9.6beta3
Date: 2016-07-30 11:59:44
Message-ID: CAB7nPqSQ=c79_Bh9-Y=ntBm3WA_5cdHqvAKxzYJdZVZ32TK+Fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Sat, Jul 30, 2016 at 5:47 AM, Stephen Frost <sfrost(at)snowman(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Branden Visser 2016-07-30 15:21:54 Query planner using hash join when merge join seems orders of magnitude faster
Previous Message Thomas Munro 2016-07-30 02:36:49 Re: Allowing multiple versions of PG under NetBSD

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-07-30 12:17:15 Re: old_snapshot_threshold allows heap:toast disagreement
Previous Message Andrew Borodin 2016-07-30 11:00:12 Re: Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC]