git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION

author Peter Eisentraut <peter@eisentraut.org>

Tue, 6 Apr 2021 08:44:26 +0000 (10:44 +0200)

committer Peter Eisentraut <peter@eisentraut.org>

Tue, 6 Apr 2021 09:49:51 +0000 (11:49 +0200)

commit 82ed7748b710e3ddce3f7ebc74af80fe4869492f

tree 777753e1b7b44a8f0848d2a43df515010dcbb201 tree

parent 266b5673b4b6bed2e9ebfe73ca967f44d6dc0e6c commit | diff

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 diff | blob | blame | history

src/backend/commands/subscriptioncmds.c diff | blob | blame | history

src/backend/parser/gram.y diff | blob | blame | history

src/bin/psql/tab-complete.c diff | blob | blame | history

src/include/nodes/parsenodes.h diff | blob | blame | history

src/test/regress/expected/subscription.out diff | blob | blame | history

src/test/regress/sql/subscription.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom