From c94e510a79bea48603a6825f71cb8d2cbf73692b Mon Sep 17 00:00:00 2001 From: Peter Smith Date: Tue, 10 Oct 2023 14:11:07 +1100 Subject: [PATCH v3] Add more links --- doc/src/sgml/ref/alter_publication.sgml | 3 ++- doc/src/sgml/ref/alter_subscription.sgml | 20 ++++++++++---------- doc/src/sgml/ref/drop_subscription.sgml | 8 +++++--- 3 files changed, 17 insertions(+), 14 deletions(-) diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index c8424bc..51a67a7 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -51,7 +51,8 @@ ALTER PUBLICATION name RENAME TO ADD and DROP clauses will add and remove one or more tables/schemas from the publication. Note that adding tables/schemas to a publication that is already subscribed to will require an - ALTER SUBSCRIPTION ... REFRESH PUBLICATION action on the + + ALTER SUBSCRIPTION ... REFRESH PUBLICATION action on the subscribing side in order to become effective. Note also that DROP TABLES IN SCHEMA will not drop any schema tables that were specified using diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index a85e04e..baf062d 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -85,7 +85,7 @@ ALTER SUBSCRIPTION name RENAME TO < Parameters - + name @@ -94,7 +94,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + CONNECTION 'conninfo' @@ -105,7 +105,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + SET PUBLICATION publication_name ADD PUBLICATION publication_name DROP PUBLICATION publication_name @@ -147,7 +147,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + REFRESH PUBLICATION @@ -192,7 +192,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + ENABLE @@ -202,7 +202,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + DISABLE @@ -212,7 +212,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + SET ( subscription_parameter [= value] [, ... ] ) @@ -232,7 +232,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + SKIP ( skip_option = value ) @@ -272,7 +272,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + new_owner @@ -281,7 +281,7 @@ ALTER SUBSCRIPTION name RENAME TO < - + new_name diff --git a/doc/src/sgml/ref/drop_subscription.sgml b/doc/src/sgml/ref/drop_subscription.sgml index 2a67bde..6212644 100644 --- a/doc/src/sgml/ref/drop_subscription.sgml +++ b/doc/src/sgml/ref/drop_subscription.sgml @@ -40,7 +40,7 @@ DROP SUBSCRIPTION [ IF EXISTS ] name DROP SUBSCRIPTION cannot be executed inside a transaction block if the subscription is associated with a replication - slot. (You can use ALTER SUBSCRIPTION to unset the + slot. (You can use ALTER SUBSCRIPTION to unset the slot.) @@ -87,9 +87,11 @@ DROP SUBSCRIPTION [ IF EXISTS ] nameDROP SUBSCRIPTION command will fail. To proceed in this situation, first disable the subscription by executing - ALTER SUBSCRIPTION ... DISABLE, and then disassociate + + ALTER SUBSCRIPTION ... DISABLE, and then disassociate it from the replication slot by executing - ALTER SUBSCRIPTION ... SET (slot_name = NONE). + + ALTER SUBSCRIPTION ... SET (slot_name = NONE). After that, DROP SUBSCRIPTION will no longer attempt any actions on a remote host. Note that if the remote replication slot still exists, it (and any related table synchronization slots) should then be -- 1.8.3.1