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

Commitd7fe24e

Browse files
committed
doc: clarify that storage parameter values are optional
In a few cases, the documented syntax specified storage parameter valuesas required.Reported-by: galiev_mr@taximaxim.ruDiscussion:https://postgr.es/m/159283163235.684.4482737698910467437@wrigleys.postgresql.orgBackpatch-through: 9.5
1 parent35d5f69 commitd7fe24e

File tree

4 files changed

+6
-6
lines changed

4 files changed

+6
-6
lines changed

‎doc/src/sgml/ref/alter_index.sgml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -25,7 +25,7 @@ ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RENA
2525
ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> SET TABLESPACE <replaceable class="parameter">tablespace_name</replaceable>
2626
ALTER INDEX <replaceable class="parameter">name</replaceable> ATTACH PARTITION <replaceable class="parameter">index_name</replaceable>
2727
ALTER INDEX <replaceable class="parameter">name</replaceable> DEPENDS ON EXTENSION <replaceable class="parameter">extension_name</replaceable>
28-
ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )
28+
ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )
2929
ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )
3030
ALTER INDEX [ IF EXISTS ] <replaceable class="parameter">name</replaceable> ALTER [ COLUMN ] <replaceable class="parameter">column_number</replaceable>
3131
SET STATISTICS <replaceable class="parameter">integer</replaceable>
@@ -110,7 +110,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable>
110110
</varlistentry>
111111

112112
<varlistentry>
113-
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )</literal></term>
113+
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )</literal></term>
114114
<listitem>
115115
<para>
116116
This form changes one or more index-method-specific storage parameters

‎doc/src/sgml/ref/alter_materialized_view.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -42,7 +42,7 @@ ALTER MATERIALIZED VIEW ALL IN TABLESPACE <replaceable class="parameter">name</r
4242
ALTER [ COLUMN ] <replaceable class="parameter">column_name</replaceable> SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
4343
CLUSTER ON <replaceable class="parameter">index_name</replaceable>
4444
SET WITHOUT CLUSTER
45-
SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )
45+
SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )
4646
RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )
4747
OWNER TO { <replaceable class="parameter">new_owner</replaceable> | CURRENT_USER | SESSION_USER }
4848
</synopsis>

‎doc/src/sgml/ref/alter_table.sgml‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -75,7 +75,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable>
7575
SET WITHOUT OIDS
7676
SET TABLESPACE <replaceable class="parameter">new_tablespace</replaceable>
7777
SET { LOGGED | UNLOGGED }
78-
SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )
78+
SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )
7979
RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )
8080
INHERIT <replaceable class="parameter">parent_table</replaceable>
8181
NO INHERIT <replaceable class="parameter">parent_table</replaceable>
@@ -681,7 +681,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
681681
</varlistentry>
682682

683683
<varlistentry>
684-
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )</literal></term>
684+
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )</literal></term>
685685
<listitem>
686686
<para>
687687
This form changes one or more storage parameters for the table. See

‎doc/src/sgml/ref/create_index.sgml‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -24,7 +24,7 @@ PostgreSQL documentation
2424
CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class="parameter">name</replaceable> ] ON [ ONLY ] <replaceable class="parameter">table_name</replaceable> [ USING <replaceable class="parameter">method</replaceable> ]
2525
( { <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ COLLATE <replaceable class="parameter">collation</replaceable> ] [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
2626
[ INCLUDE ( <replaceable class="parameter">column_name</replaceable> [, ...] ) ]
27-
[ WITH ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] ) ]
27+
[ WITH ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
2828
[ TABLESPACE <replaceable class="parameter">tablespace_name</replaceable> ]
2929
[ WHERE <replaceable class="parameter">predicate</replaceable> ]
3030
</synopsis>

0 commit comments

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