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
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/82ed7748b710e3ddce3f7ebc74af80fe4869492f
Modified Files
--------------
doc/src/sgml/ref/alter_subscription.sgml | 19 +++-
src/backend/commands/subscriptioncmds.c | 177 +++++++++++++++++++++++++----
src/backend/parser/gram.y | 22 +++-
src/bin/psql/tab-complete.c | 12 +-
src/include/nodes/parsenodes.h | 4 +-
src/test/regress/expected/subscription.out | 39 +++++++
src/test/regress/sql/subscription.sql | 31 +++++
7 files changed, 267 insertions(+), 37 deletions(-)