From c5366ed1840259c5092e33bfe6570227d3858537 Mon Sep 17 00:00:00 2001 From: Japin Li Date: Tue, 26 Jan 2021 17:54:44 +0800 Subject: [PATCH v2 3/4] Add documentation for ALTER SUBSCRIPTION...ADD/DROP PUBLICATION --- doc/src/sgml/ref/alter_subscription.sgml | 68 ++++++++++++++++++++++++ 1 file changed, 68 insertions(+) diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index db5e59f707..97c427e0f4 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -23,6 +23,8 @@ PostgreSQL documentation ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name SET PUBLICATION publication_name [, ...] [ WITH ( set_publication_option [= value] [, ... ] ) ] +ALTER SUBSCRIPTION name ADD PUBLICATION publication_name [, ...] [ WITH ( set_publication_option [= value] [, ... ] ) ] +ALTER SUBSCRIPTION name DROP PUBLICATION publication_name [, ...] [ WITH ( set_publication_option [= value] [, ... ] ) ] ALTER SUBSCRIPTION name REFRESH PUBLICATION [ WITH ( refresh_option [= value] [, ... ] ) ] ALTER SUBSCRIPTION name ENABLE ALTER SUBSCRIPTION name DISABLE @@ -107,6 +109,72 @@ ALTER SUBSCRIPTION name RENAME TO < + + ADD PUBLICATION publication_name + + + Add list of publications to subscription. See + for more information. + By default this command will also act like REFRESH + PUBLICATION. + + + + set_publication_option specifies additional + options for this operation. The supported options are: + + + + refresh (boolean) + + + When false, the command will not try to refresh table information. + REFRESH PUBLICATION should then be executed separately. + The default is true. + + + + + + Additionally, refresh options as described + under REFRESH PUBLICATION may be specified. + + + + + + DROP PUBLICATION publication_name + + + Drop list of publications from subscription. See + for more information. + By default this command will also act like REFRESH + PUBLICATION. + + + + set_publication_option specifies additional + options for this operation. The supported options are: + + + + refresh (boolean) + + + When false, the command will not try to refresh table information. + REFRESH PUBLICATION should then be executed separately. + The default is true. + + + + + + Additionally, refresh options as described + under REFRESH PUBLICATION may be specified. + + + + REFRESH PUBLICATION -- 2.30.0