diff options
| -rw-r--r-- | doc/src/sgml/ref/alter_publication.sgml | 40 | ||||
| -rw-r--r-- | doc/src/sgml/ref/alter_subscription.sgml | 39 |
2 files changed, 39 insertions, 40 deletions
diff --git a/doc/src/sgml/ref/alter_publication.sgml b/doc/src/sgml/ref/alter_publication.sgml index 858231fbcbf..05bd57d9cab 100644 --- a/doc/src/sgml/ref/alter_publication.sgml +++ b/doc/src/sgml/ref/alter_publication.sgml @@ -29,11 +29,11 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> WITH ( <repl | PUBLISH UPDATE | NOPUBLISH UPDATE | 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 [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...] ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> SET TABLE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...] ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...] +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> </synopsis> </refsynopsisdiv> @@ -80,24 +80,6 @@ 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> @@ -124,6 +106,24 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE [ </para> </listitem> </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> </variablelist> </refsect1> diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index 35aeb6af413..5dae4aebd63 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -35,11 +35,11 @@ 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 +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> </synopsis> </refsynopsisdiv> @@ -72,24 +72,6 @@ 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> <term><literal>SYNCHRONOUS_COMMIT = <replaceable class="PARAMETER">synchronous_commit</replaceable></literal></term> @@ -156,6 +138,23 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE </listitem> </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> </variablelist> </refsect1> |