Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit246ec4a

Browse files
committed
doc: Fix misleading synopsis for CREATE/ALTER PUBLICATION.
The documentation for CREATE/ALTER PUBLICATION previously showed: [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ] [, ... ]to indicate that the table/column specification could be repeated.However, placing [, ... ] directly after a multi-part construct wasmisleading and made it unclear which portion was repeatable.This commit introduces a new term, table_and_columns, to represent: [ ONLY ] table_name [ * ] [ ( column_name [, ... ] ) ] [ WHERE ( expression ) ]and updates the synopsis to use: table_and_columns [, ... ]which clearly identifies the repeatable element.Backpatched to v15, where the misleading syntax was introduced.Author: Peter Smith <smithpb2250@gmail.com>Reviewed-by: Chao Li <lic@highgo.com>Reviewed-by: Fujii Masao <masao.fujii@gmail.com>Discussion:https://postgr.es/m/CAHut+PtsyvYL3KmA6C8f0ZpXQ=7FEqQtETVy-BOF+cm9WPvfMQ@mail.gmail.comBackpatch-through: 15
1 parent9e8fa05 commit246ec4a

File tree

2 files changed

+13
-5
lines changed

2 files changed

+13
-5
lines changed

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

Lines changed: 6 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -30,13 +30,17 @@ ALTER PUBLICATION <replaceable class="parameter">name</replaceable> RENAME TO <r
3030

3131
<phrase>where <replaceable class="parameter">publication_object</replaceable> is one of:</phrase>
3232

33-
TABLE[ ONLY ]<replaceable class="parameter">table_name</replaceable> [ * ] [ ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ] [ WHERE ( <replaceable class="parameter">expression</replaceable> ) ] [, ... ]
33+
TABLE <replaceable class="parameter">table_and_columns</replaceable> [, ... ]
3434
TABLES IN SCHEMA { <replaceable class="parameter">schema_name</replaceable> | CURRENT_SCHEMA } [, ... ]
3535

36-
<phrase>where <replaceable class="parameter">publication_drop_object</replaceable> is one of:</phrase>
36+
<phrase>and <replaceable class="parameter">publication_drop_object</replaceable> is one of:</phrase>
3737

3838
TABLE [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] [, ... ]
3939
TABLES IN SCHEMA { <replaceable class="parameter">schema_name</replaceable> | CURRENT_SCHEMA } [, ... ]
40+
41+
<phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase>
42+
43+
[ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] [ ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ] [ WHERE ( <replaceable class="parameter">expression</replaceable> ) ]
4044
</synopsis>
4145
</refsynopsisdiv>
4246

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

Lines changed: 7 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -22,18 +22,22 @@ PostgreSQL documentation
2222
<refsynopsisdiv>
2323
<synopsis>
2424
CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
25-
[ FOR { <replaceable class="parameter">publication_object</replaceable> [, ... ] | <replaceable class="parameter">all_publication_object</replaceable> [, ... ] } ]
25+
[ FOR { <replaceable class="parameter">publication_object</replaceable> [, ... ] | <replaceable class="parameter">publication_all_object</replaceable> [, ... ] } ]
2626
[ WITH ( <replaceable class="parameter">publication_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
2727

2828
<phrase>where <replaceable class="parameter">publication_object</replaceable> is one of:</phrase>
2929

30-
TABLE[ ONLY ]<replaceable class="parameter">table_name</replaceable> [ * ] [ ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ] [ WHERE ( <replaceable class="parameter">expression</replaceable> ) ] [, ... ]
30+
TABLE <replaceable class="parameter">table_and_columns</replaceable> [, ... ]
3131
TABLES IN SCHEMA { <replaceable class="parameter">schema_name</replaceable> | CURRENT_SCHEMA } [, ... ]
3232

33-
<phrase>where <replaceable class="parameter">all_publication_object</replaceable> is one of:</phrase>
33+
<phrase>and <replaceable class="parameter">publication_all_object</replaceable> is one of:</phrase>
3434

3535
ALL TABLES
3636
ALL SEQUENCES
37+
38+
<phrase>and <replaceable class="parameter">table_and_columns</replaceable> is:</phrase>
39+
40+
[ ONLY ] <replaceable class="parameter">table_name</replaceable> [ * ] [ ( <replaceable class="parameter">column_name</replaceable> [, ... ] ) ] [ WHERE ( <replaceable class="parameter">expression</replaceable> ) ]
3741
</synopsis>
3842
</refsynopsisdiv>
3943

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp