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

From Bharath Rupireddy
Subject Re: alter subscription drop publication fixes
Date
Msg-id CALj2ACW+VZqEs_HAEx2bu_60ro+59hzdLvFeD3q1O6eMVkStbQ@mail.gmail.com
Whole thread Raw
In response to Re: alter subscription drop publication fixes  (vignesh C <vignesh21@gmail.com>)
Responses Re: alter subscription drop publication fixes
List pgsql-hackers
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."

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: compute_query_id and pg_stat_statements
Next
From: Bruce Momjian
Date:
Subject: Re: PG 14 release notes, first draft