From 19b2182a747675ac0f509b13a9c86908edaa0385 Mon Sep 17 00:00:00 2001 From: Peter Smith Date: Wed, 19 Oct 2022 12:58:50 +1100 Subject: [PATCH v2] clarify behavior of specifying a parameter with no value Modified docs for - CREATE/ALTER PUBLICATION - CREATE/ALTER SUBSCRIPTION --- doc/src/sgml/ref/alter_publication.sgml | 3 +++ doc/src/sgml/ref/alter_subscription.sgml | 12 +++++++++--- doc/src/sgml/ref/create_publication.sgml | 11 +++++++++-- doc/src/sgml/ref/create_subscription.sgml | 5 +++++ 4 files changed, 26 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index c84b11f..2b4eb1f 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -148,6 +148,9 @@ ALTER PUBLICATION name RENAME TO This clause alters publication parameters originally set by . See there for more information. + For boolean parameters the + value can be omitted, which + is equivalent to specifying TRUE. diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index 1e8d720..759b7a3 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -132,7 +132,9 @@ ALTER SUBSCRIPTION name RENAME TO < When false, the command will not try to refresh table information. REFRESH PUBLICATION should then be executed separately. - The default is true. + The default is true. The + value can be omitted, + which is equivalent to specifying TRUE. @@ -166,7 +168,9 @@ ALTER SUBSCRIPTION name RENAME TO < Specifies whether to copy pre-existing data in the publications that are being subscribed to when the replication starts. - The default is true. + The default is true. The + value can be omitted, + which is equivalent to specifying TRUE. Previously subscribed tables are not copied, even if a table's row @@ -214,7 +218,9 @@ ALTER SUBSCRIPTION name RENAME TO < synchronous_commit, binary, streaming, disable_on_error, and - origin. + origin. For boolean parameters the + value can be omitted, which + is equivalent to specifying TRUE. diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index e229384..d8015af 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -162,8 +162,15 @@ CREATE PUBLICATION name WITH ( publication_parameter [= value] [, ... ] ) - This clause specifies optional parameters for a publication. The - following parameters are supported: + This clause specifies optional parameters for a publication. + + + For boolean parameters the + value can be omitted, which + is equivalent to specifying TRUE. + + + The following parameters are supported: diff --git a/doc/src/sgml/ref/create_subscription.sgml b/doc/src/sgml/ref/create_subscription.sgml index f9a1776..9406aa9 100644 --- a/doc/src/sgml/ref/create_subscription.sgml +++ b/doc/src/sgml/ref/create_subscription.sgml @@ -96,6 +96,11 @@ CREATE SUBSCRIPTION subscription_name This clause specifies optional parameters for a subscription. + + For boolean parameters the + value can be omitted, which + is equivalent to specifying TRUE. + The following parameters control what happens during subscription creation: -- 1.8.3.1