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

Commitdb9f287

Browse files
committed
doc: Add referential actions to CREATE/ALTER TABLE synopsis
The general constraint synopsis references "referential_action", butthis was not further defined in the synopsis section. Compared to thelevel of detail that the synopsis gives to other subclauses, thisshould surely be there.extracted from a patch by Paul Martinez <hellopfm@gmail.com>Discussion:https://www.postgresql.org/message-id/flat/CACqFVBZQyMYJV=njbSMxf+rbDHpx=W=B7AEaMKn8dWn9OZJY7w@mail.gmail.com
1 parent098c134 commitdb9f287

File tree

2 files changed

+8
-0
lines changed

2 files changed

+8
-0
lines changed

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

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -135,6 +135,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
135135
<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>
136136

137137
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
138+
139+
<phrase><replaceable class="parameter">referential_action</replaceable> in a <literal>FOREIGN KEY</literal>/<literal>REFERENCES</literal> constraint is:</phrase>
140+
141+
{ NO ACTION | RESTRICT | CASCADE | SET NULL | SET DEFAULT }
138142
</synopsis>
139143
</refsynopsisdiv>
140144

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -105,6 +105,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
105105
<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>
106106

107107
{ <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
108+
109+
<phrase><replaceable class="parameter">referential_action</replaceable> in a <literal>FOREIGN KEY</literal>/<literal>REFERENCES</literal> constraint is:</phrase>
110+
111+
{ NO ACTION | RESTRICT | CASCADE | SET NULL | SET DEFAULT }
108112
</synopsis>
109113

110114
</refsynopsisdiv>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp