pgsql: ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION

Started by Peter Eisentrautabout 5 years ago1 messagescomitters

peter_e@gmx.net

about 5 years ago

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: /messages/by-id/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(-)