From a6e7d591d0129bc7f1f186cb40a6ebd7963956ab Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Thu, 13 Apr 2017 11:29:53 +0900 Subject: [PATCH] Improve documentations for ALTER PUBLICATION and ALTER SUBSCRIPTION. Discussion: http://postgr.es/m/CAD21AoC32YgtateNqTFXzTJmHHe6hXs4cpJTND3n-Ts8f-aMqw@mail.gmail.com --- doc/src/sgml/ref/alter_publication.sgml | 19 +++++++++++++++++++ doc/src/sgml/ref/alter_subscription.sgml | 19 +++++++++++++++++++ 2 files changed, 38 insertions(+) diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 776661bbeb..0a965b3bbf 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -30,6 +30,7 @@ ALTER PUBLICATION name WITH ( name OWNER TO { new_owner | CURRENT_USER | SESSION_USER } +ALTER PUBLICATION name RENAME TO new_name ALTER PUBLICATION name ADD TABLE table_name [, ...] ALTER PUBLICATION name SET TABLE table_name [, ...] ALTER PUBLICATION name DROP TABLE table_name [, ...] @@ -78,6 +79,24 @@ ALTER PUBLICATION name DROP TABLE < + + new_owner + + + The user name of the new owner of the publication. + + + + + + new_name + + + The new name for the publication. + + + + PUBLISH INSERT NOPUBLISH INSERT diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index 0e332bc143..640fac0a15 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -35,6 +35,7 @@ ALTER SUBSCRIPTION name REFRESH PUB COPY DATA | NOCOPY DATA ALTER SUBSCRIPTION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER } +ALTER SUBSCRIPTION name RENAME TO new_name ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name ENABLE ALTER SUBSCRIPTION name DISABLE @@ -69,6 +70,24 @@ ALTER SUBSCRIPTION name DISABLE + + new_owner + + + The user name of the new owner of the subscription. + + + + + + new_name + + + The new name for the subscription. + + + + CONNECTION 'conninfo' SLOT NAME = slot_name -- 2.40.0