Commitdb9f287

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 commitdb9f287Copy full SHA for db9f287

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -135,6 +135,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`135`	`135`	`<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>`
`136`	`136`
`137`	`137`	`{ <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 }`
`138`	`142`	`</synopsis>`
`139`	`143`	`</refsynopsisdiv>`
`140`	`144`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -105,6 +105,10 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`105`	`105`	`<phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>`
`106`	`106`
`107`	`107`	`{ <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 }`
`108`	`112`	`</synopsis>`
`109`	`113`
`110`	`114`	`</refsynopsisdiv>`

Comments

(0)