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

Commitaa90d99

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 parent2a06cb8 commitaa90d99

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>
@@ -113,7 +113,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="parameter">name</replaceable>
113113
</varlistentry>
114114

115115
<varlistentry>
116-
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )</literal></term>
116+
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )</literal></term>
117117
<listitem>
118118
<para>
119119
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
@@ -76,7 +76,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable>
7676
SET WITHOUT OIDS
7777
SET TABLESPACE <replaceable class="parameter">new_tablespace</replaceable>
7878
SET { LOGGED | UNLOGGED }
79-
SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )
79+
SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )
8080
RESET ( <replaceable class="parameter">storage_parameter</replaceable> [, ... ] )
8181
INHERIT <replaceable class="parameter">parent_table</replaceable>
8282
NO INHERIT <replaceable class="parameter">parent_table</replaceable>
@@ -702,7 +702,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
702702
</varlistentry>
703703

704704
<varlistentry>
705-
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable> = <replaceable class="parameter">value</replaceable> [, ... ] )</literal></term>
705+
<term><literal>SET ( <replaceable class="parameter">storage_parameter</replaceable>[= <replaceable class="parameter">value</replaceable>] [, ... ] )</literal></term>
706706
<listitem>
707707
<para>
708708
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> [ ( <replaceable class="parameter">opclass_parameter</replaceable> = <replaceable class="parameter">value</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