Skip to content

Commit e950024

Browse files
committed
doc: Improve order in ALTER PUBLICATION/SUBSCRIPTION ref pages
Move the OWNER and RENAME clauses to the end, so the interesting functionality is listed first. This is more typical on nearby reference pages, whereas the previous order was the order in which the clauses were added.
1 parent 0d1e1f0 commit e950024

File tree

2 files changed

+39
-40
lines changed

2 files changed

+39
-40
lines changed

doc/src/sgml/ref/alter_publication.sgml

+20-20
Original file line numberDiff line numberDiff line change
@@ -29,11 +29,11 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> WITH ( <repl
2929
| PUBLISH UPDATE | NOPUBLISH UPDATE
3030
| PUBLISH DELETE | NOPUBLISH DELETE
3131

32-
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER }
33-
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
3432
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> ADD TABLE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...]
3533
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> SET TABLE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...]
3634
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [, ...]
35+
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER }
36+
ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
3737
</synopsis>
3838
</refsynopsisdiv>
3939

@@ -79,24 +79,6 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE [
7979
</listitem>
8080
</varlistentry>
8181

82-
<varlistentry>
83-
<term><replaceable class="parameter">new_owner</replaceable></term>
84-
<listitem>
85-
<para>
86-
The user name of the new owner of the publication.
87-
</para>
88-
</listitem>
89-
</varlistentry>
90-
91-
<varlistentry>
92-
<term><replaceable class="parameter">new_name</replaceable></term>
93-
<listitem>
94-
<para>
95-
The new name for the publication.
96-
</para>
97-
</listitem>
98-
</varlistentry>
99-
10082
<varlistentry>
10183
<term><literal>PUBLISH INSERT</literal></term>
10284
<term><literal>NOPUBLISH INSERT</literal></term>
@@ -124,6 +106,24 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE [
124106
</para>
125107
</listitem>
126108
</varlistentry>
109+
110+
<varlistentry>
111+
<term><replaceable class="parameter">new_owner</replaceable></term>
112+
<listitem>
113+
<para>
114+
The user name of the new owner of the publication.
115+
</para>
116+
</listitem>
117+
</varlistentry>
118+
119+
<varlistentry>
120+
<term><replaceable class="parameter">new_name</replaceable></term>
121+
<listitem>
122+
<para>
123+
The new name for the publication.
124+
</para>
125+
</listitem>
126+
</varlistentry>
127127
</variablelist>
128128
</refsect1>
129129

doc/src/sgml/ref/alter_subscription.sgml

+19-20
Original file line numberDiff line numberDiff line change
@@ -35,11 +35,11 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> REFRESH PUB
3535

3636
COPY DATA | NOCOPY DATA
3737

38-
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER }
39-
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
4038
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> CONNECTION '<replaceable>conninfo</replaceable>'
4139
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> ENABLE
4240
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE
41+
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> OWNER TO { <replaceable>new_owner</replaceable> | CURRENT_USER | SESSION_USER }
42+
ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable>new_name</replaceable>
4343
</synopsis>
4444
</refsynopsisdiv>
4545

@@ -71,24 +71,6 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE
7171
</listitem>
7272
</varlistentry>
7373

74-
<varlistentry>
75-
<term><replaceable class="parameter">new_owner</replaceable></term>
76-
<listitem>
77-
<para>
78-
The user name of the new owner of the subscription.
79-
</para>
80-
</listitem>
81-
</varlistentry>
82-
83-
<varlistentry>
84-
<term><replaceable class="parameter">new_name</replaceable></term>
85-
<listitem>
86-
<para>
87-
The new name for the subscription.
88-
</para>
89-
</listitem>
90-
</varlistentry>
91-
9274
<varlistentry>
9375
<term><literal>CONNECTION '<replaceable class="parameter">conninfo</replaceable>'</literal></term>
9476
<term><literal>SLOT NAME = <replaceable class="parameter">slot_name</replaceable></literal></term>
@@ -156,6 +138,23 @@ ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> DISABLE
156138
</listitem>
157139
</varlistentry>
158140

141+
<varlistentry>
142+
<term><replaceable class="parameter">new_owner</replaceable></term>
143+
<listitem>
144+
<para>
145+
The user name of the new owner of the subscription.
146+
</para>
147+
</listitem>
148+
</varlistentry>
149+
150+
<varlistentry>
151+
<term><replaceable class="parameter">new_name</replaceable></term>
152+
<listitem>
153+
<para>
154+
The new name for the subscription.
155+
</para>
156+
</listitem>
157+
</varlistentry>
159158
</variablelist>
160159
</refsect1>
161160

0 commit comments

Comments
 (0)