Re: Patch: Add --no-comments to skip COMMENTs with pg_dump

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Fabrízio Mello <fabriziomello(at)gmail(dot)com>, Robins Tharakan <tharakan(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, David Fetter <david(at)fetter(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: Patch: Add --no-comments to skip COMMENTs with pg_dump
Date: 2017-09-06 23:42:07
Message-ID: CAB7nPqQjHw-amS60+2eyU7aE9R_sTvbb_5sEtVkw9xwAK-zZ4A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Sep 7, 2017 at 1:43 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Wed, Sep 6, 2017 at 12:26 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>>> I'd personally be fine with --no-whatever for any whatever that might
>>>> be a subsidiary property of database objects. We've got
>>>> --no-security-labels, --no-tablespaces, --no-owner, and
>>>> --no-privileges already, so what's wrong with --no-comments?
>>>>
>>>> (We've also got --no-publications; I think it's arguable whether that
>>>> is the same kind of thing.)
>>>
>>> And --no-subscriptions in the same bucket.
>>
>> Yes, it is. I was suggesting that we remove those as well.

FWIW, I do too. They are useful for given application code paths.

> That seems like a non-starter to me. I have used those options many
> times to solve real problems, and I'm sure other people have as well.
> We wouldn't have ended up with all of these options if users didn't
> want to control such things.

As there begins to be many switches of this kind and much code
duplication, I think that some refactoring into a more generic switch
infrastructure would be nicer.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2017-09-06 23:51:34 Re: Setting pd_lower in GIN metapage
Previous Message Tom Lane 2017-09-06 22:55:08 Re: Replication vs. float timestamps is a disaster