Re: alter subscription drop publication fixes - Mailing list pgsql-hackers

From vignesh C
Subject Re: alter subscription drop publication fixes
Date
Msg-id CALDaNm3svMg+hMA9GsJsUQ75HXtpjpAh2gk=8yZfgAnA9BMsnA@mail.gmail.com
Whole thread Raw
In response to Re: alter subscription drop publication fixes  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
On Thu, May 13, 2021 at 8:13 PM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> On Thu, May 13, 2021 at 7:43 PM vignesh C <vignesh21@gmail.com> wrote:
> > I have separated the Drop publication documentation contents. There
> > are some duplicate contents but the readability is slightly better.
> > Thoughts?
>
> -ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable>
> DROP PUBLICATION <replaceable
> class="parameter">publication_name</replaceable> [, ...] [ WITH (
> <replaceable class="parameter">set_publication_option</replaceable> [=
> <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
> +ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable>
> DROP PUBLICATION <replaceable
> class="parameter">publication_name</replaceable> [, ...] [ WITH (
> refresh [= <replaceable class="parameter">value</replaceable>] ) ]
>
> IMO, let's not list the "refresh" option directly here. If we don't
> want to add a new list of operations "drop_publication_opition", you
> could just mention a note "Except for DROP PUBLICATION, the refresh
> options as described under REFRESH PUBLICATION may be specified." or
> "Additionally, refresh options as described under REFRESH PUBLICATION
> may be specified, except for DROP PUBLICATION."

Thanks for the comment, the attached v3 patch has the changes for the
same. I also made another change to change set_publication_option to
publication_option as it is common for SET/ADD & DROP.

Regards,
Vignesh

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bracket, brace, parenthesis
Next
From: Julien Rouhaud
Date:
Subject: Re: compute_query_id and pg_stat_statements