ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION
authorPeter Eisentraut <peter@eisentraut.org>
Tue, 6 Apr 2021 08:44:26 +0000 (10:44 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Tue, 6 Apr 2021 09:49:51 +0000 (11:49 +0200)
commit82ed7748b710e3ddce3f7ebc74af80fe4869492f
tree777753e1b7b44a8f0848d2a43df515010dcbb201
parent266b5673b4b6bed2e9ebfe73ca967f44d6dc0e6c
ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION

At present, if we want to update publications in a subscription, we
can use SET PUBLICATION.  However, it requires supplying all
publications that exists and the new publications.  If we want to add
new publications, it's inconvenient.  The new syntax only supplies the
new publications.  When the refresh is true, it only refreshes the new
publications.

Author: Japin Li <japinli@hotmail.com>
Author: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/MEYP282MB166939D0D6C480B7FBE7EFFBB6BC0@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
doc/src/sgml/ref/alter_subscription.sgml
src/backend/commands/subscriptioncmds.c
src/backend/parser/gram.y
src/bin/psql/tab-complete.c
src/include/nodes/parsenodes.h
src/test/regress/expected/subscription.out
src/test/regress/sql/subscription.sql