ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION
Peter Eisentraut <peter@eisentraut.org>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_subscription.sgml | modified | +14 −5 |
| src/backend/commands/subscriptioncmds.c | modified | +152 −25 |
| src/backend/parser/gram.y | modified | +21 −1 |
| src/bin/psql/tab-complete.c | modified | +7 −5 |
| src/include/nodes/parsenodes.h | modified | +3 −1 |
| src/test/regress/expected/subscription.out | modified | +39 −0 |
| src/test/regress/sql/subscription.sql | modified | +31 −0 |
Documentation touched
Discussion
- Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax 37 messages · 2021-01-26 → 2021-04-07