Skip to content

Commit 1fe3325

Browse files
peterepetere
committed
Document that ONLY can be specified in publication commands
Author: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
1 parent b6dd127 commit 1fe3325

File tree

4 files changed

+48
-6
lines changed

4 files changed

+48
-6
lines changed

‎doc/src/sgml/ref/alter_publication.sgml

Lines changed: 8 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -31,9 +31,9 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> WITH ( <repl
3131

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

@@ -116,7 +116,11 @@ ALTER PUBLICATION <replaceable class="PARAMETER">name</replaceable> DROP TABLE <
116116
<term><replaceable class="parameter">table_name</replaceable></term>
117117
<listitem>
118118
<para>
119-
Name of an existing table.
119+
Name of an existing table. If <literal>ONLY</> is specified before the
120+
table name, only that table is affected. If <literal>ONLY</> is not
121+
specified, the table and all its descendant tables (if any) are
122+
affected. Optionally, <literal>*</> can be specified after the table
123+
name to explicitly indicate that descendant tables are included.
120124
</para>
121125
</listitem>
122126
</varlistentry>

‎doc/src/sgml/ref/create_publication.sgml

Lines changed: 7 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ PostgreSQL documentation
2222
<refsynopsisdiv>
2323
<synopsis>
2424
CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
25-
[ FOR TABLE <replaceable class="parameter">table_name</replaceable> [, ...]
25+
[ FOR TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] [, ...]
2626
| FOR ALL TABLES ]
2727
[ WITH ( <replaceable class="parameter">option</replaceable> [, ... ] ) ]
2828

@@ -68,7 +68,12 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
6868
<term><literal>FOR TABLE</literal></term>
6969
<listitem>
7070
<para>
71-
Specifies a list of tables to add to the publication.
71+
Specifies a list of tables to add to the publication. If
72+
<literal>ONLY</> is specified before the table name, only
73+
that table is added to the publication. If <literal>ONLY</> is not
74+
specified, the table and all its descendant tables (if any) are added.
75+
Optionally, <literal>*</> can be specified after the table name to
76+
explicitly indicate that descendant tables are included.
7277
</para>
7378
</listitem>
7479
</varlistentry>

‎src/test/regress/expected/publication.out

Lines changed: 23 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -71,6 +71,29 @@ Publications:
7171

7272
DROP TABLE testpub_tbl2;
7373
DROP PUBLICATION testpub_foralltables;
74+
CREATE TABLE testpub_tbl3 (a int);
75+
CREATE TABLE testpub_tbl3a (b text) INHERITS (testpub_tbl3);
76+
CREATE PUBLICATION testpub3 FOR TABLE testpub_tbl3;
77+
CREATE PUBLICATION testpub4 FOR TABLE ONLY testpub_tbl3;
78+
\dRp+ testpub3
79+
Publication testpub3
80+
Inserts | Updates | Deletes
81+
---------+---------+---------
82+
t | t | t
83+
Tables:
84+
"public.testpub_tbl3"
85+
"public.testpub_tbl3a"
86+
87+
\dRp+ testpub4
88+
Publication testpub4
89+
Inserts | Updates | Deletes
90+
---------+---------+---------
91+
t | t | t
92+
Tables:
93+
"public.testpub_tbl3"
94+
95+
DROP TABLE testpub_tbl3, testpub_tbl3a;
96+
DROP PUBLICATION testpub3, testpub4;
7497
-- fail - view
7598
CREATE PUBLICATION testpub_fortbl FOR TABLE testpub_view;
7699
ERROR: "testpub_view" is not a table

‎src/test/regress/sql/publication.sql

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -44,6 +44,16 @@ SELECT pubname, puballtables FROM pg_publication WHERE pubname = 'testpub_forall
4444
DROP TABLE testpub_tbl2;
4545
DROP PUBLICATION testpub_foralltables;
4646

47+
CREATE TABLE testpub_tbl3 (a int);
48+
CREATE TABLE testpub_tbl3a (b text) INHERITS (testpub_tbl3);
49+
CREATE PUBLICATION testpub3 FOR TABLE testpub_tbl3;
50+
CREATE PUBLICATION testpub4 FOR TABLE ONLY testpub_tbl3;
51+
\dRp+ testpub3
52+
\dRp+ testpub4
53+
54+
DROP TABLE testpub_tbl3, testpub_tbl3a;
55+
DROP PUBLICATION testpub3, testpub4;
56+
4757
-- fail - view
4858
CREATE PUBLICATION testpub_fortbl FOR TABLE testpub_view;
4959
CREATE PUBLICATION testpub_fortbl FOR TABLE testpub_tbl1, pub_test.testpub_nopk;

0 commit comments

Comments
 (0)