From: Japin Li Date: Tue, 26 Jan 2021 17:54:44 +0800 Subject: [PATCH v4 4/5] Add documentation for ALTER SUBSCRIPTION...ADD/DROP PUBLICATION --- doc/src/sgml/ref/alter_subscription.sgml | 65 ++++++++++++++++++++++++ 1 file changed, 65 insertions(+) diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index db5e59f707..e6e81ce7a3 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,69 @@ 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, except it only affect on added publications. + + + + 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, except it only affect on dropped publications. + + + + 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. + + + + + + + + REFRESH PUBLICATION -- 2.30.0 --=-=-= Content-Type: text/x-patch Content-Disposition: attachment; filename=v4-0005-Add-tab-complete-for-ALTER-SUBSCRIPTION.ADD-DROP.patch