diff options
| author | Fujii Masao <fujii@postgresql.org> | 2017-04-13 11:29:53 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2017-04-13 11:29:53 +0900 |
| commit | a6e7d591d0129bc7f1f186cb40a6ebd7963956ab (patch) | |
| tree | e8d000dc0eecd06a4f1a185980e9987f81017abd /doc/src | |
| parent | c525f740661104e3d8578a133ed6b4a8cd7028ac (diff) | |
Improve documentations for ALTER PUBLICATION and ALTER SUBSCRIPTION.
Discussion: http://postgr.es/m/CAD21AoC32YgtateNqTFXzTJmHHe6hXs4cpJTND3n-Ts8f-aMqw@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_publication.sgml | 19 | ||||
| -rw-r--r-- | doc/src/sgml/ref/alter_subscription.sgml | 19 |
2 files changed, 38 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 776661bbeb3..0a965b3bbf8 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -30,6 +30,7 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> WITH ( <repl | PUBLISH DELETE | NOPUBLISH DELETE ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER } +ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable> ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> ADD TABLE <replaceable class="PARAMETER">table_name</replaceable> [, ...] ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> SET TABLE <replaceable class="PARAMETER">table_name</replaceable> [, ...] ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE <replaceable class="PARAMETER">table_name</replaceable> [, ...] @@ -79,6 +80,24 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE < </varlistentry> <varlistentry> + <term><replaceable class="parameter">new_owner</replaceable></term> + <listitem> + <para> + The user name of the new owner of the publication. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">new_name</replaceable></term> + <listitem> + <para> + The new name for the publication. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>PUBLISH INSERT</literal></term> <term><literal>NOPUBLISH INSERT</literal></term> <term><literal>PUBLISH UPDATE</literal></term> diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index 0e332bc143b..640fac0a159 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -35,6 +35,7 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> REFRESH PUB COPY DATA | NOCOPY DATA ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER } +ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable> ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> CONNECTION '<replaceable>conninfo</replaceable>' ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> ENABLE ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE @@ -70,6 +71,24 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE </varlistentry> <varlistentry> + <term><replaceable class="parameter">new_owner</replaceable></term> + <listitem> + <para> + The user name of the new owner of the subscription. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="parameter">new_name</replaceable></term> + <listitem> + <para> + The new name for the subscription. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>CONNECTION '<replaceable class="parameter">conninfo</replaceable>'</literal></term> <term><literal>SLOT NAME = <replaceable class="parameter">slot_name</replaceable></literal></term> <listitem> |