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

Commitbabe5c1

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 parentd0a642f commitbabe5c1

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
@@ -24,7 +24,7 @@ PostgreSQL documentation
2424
ALTER INDEX [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable class="PARAMETER">new_name</replaceable>
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> DEPENDS ON EXTENSION <replaceable class="PARAMETER">extension_name</replaceable>
27-
ALTER INDEX [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> SET ( <replaceable class="PARAMETER">storage_parameter</replaceable> = <replaceable class="PARAMETER">value</replaceable> [, ... ] )
27+
ALTER INDEX [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> SET ( <replaceable class="PARAMETER">storage_parameter</replaceable>[= <replaceable class="PARAMETER">value</replaceable>] [, ... ] )
2828
ALTER INDEX [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> RESET ( <replaceable class="PARAMETER">storage_parameter</replaceable> [, ... ] )
2929
ALTER INDEX ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable> [ OWNED BY <replaceable class="PARAMETER">role_name</replaceable> [, ... ] ]
3030
SET TABLESPACE <replaceable class="PARAMETER">new_tablespace</replaceable> [ NOWAIT ]
@@ -84,7 +84,7 @@ ALTER INDEX ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
8484
</varlistentry>
8585

8686
<varlistentry>
87-
<term><literal>SET ( <replaceable class="PARAMETER">storage_parameter</replaceable> = <replaceable class="PARAMETER">value</replaceable> [, ... ] )</literal></term>
87+
<term><literal>SET ( <replaceable class="PARAMETER">storage_parameter</replaceable>[= <replaceable class="PARAMETER">value</replaceable>] [, ... ] )</literal></term>
8888
<listitem>
8989
<para>
9090
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>
@@ -607,7 +607,7 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable>
607607
</varlistentry>
608608

609609
<varlistentry>
610-
<term><literal>SET ( <replaceable class="PARAMETER">storage_parameter</replaceable> = <replaceable class="PARAMETER">value</replaceable> [, ... ] )</literal></term>
610+
<term><literal>SET ( <replaceable class="PARAMETER">storage_parameter</replaceable>[= <replaceable class="PARAMETER">value</replaceable>] [, ... ] )</literal></term>
611611
<listitem>
612612
<para>
613613
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
@@ -23,7 +23,7 @@ PostgreSQL documentation
2323
<synopsis>
2424
CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class="parameter">name</replaceable> ] ON <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 } ] [, ...] )
26-
[ WITH ( <replaceable class="PARAMETER">storage_parameter</replaceable> = <replaceable class="PARAMETER">value</replaceable> [, ... ] ) ]
26+
[ WITH ( <replaceable class="PARAMETER">storage_parameter</replaceable>[= <replaceable class="PARAMETER">value</replaceable>] [, ... ] ) ]
2727
[ TABLESPACE <replaceable class="parameter">tablespace_name</replaceable> ]
2828
[ WHERE <replaceable class="parameter">predicate</replaceable> ]
2929
</synopsis>

0 commit comments

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