Commit4200fea

committed

doc: fix ALTER DOMAIN domain_constraint to spell out options

It used to refer to CREATE DOMAIN, but CREATE DOMAIN allows NULL, whileALTER DOMAIN does not.Reported-by: elionescu@yahoo.comDiscussion:https://postgr.es/m/172225092461.915373.6103973717483380183@wrigleys.postgresql.orgBackpatch-through: 12

1 parent94a8c19 commit4200feaCopy full SHA for 4200fea

File tree

-2

lines changed

-2

lines changed

Lines changed: 6 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -41,6 +41,11 @@ ALTER DOMAIN <replaceable class="parameter">name</replaceable>`
`41`	`41`	`RENAME TO <replaceable class="parameter">new_name</replaceable>`
`42`	`42`	`ALTER DOMAIN <replaceable class="parameter">name</replaceable>`
`43`	`43`	`SET SCHEMA <replaceable class="parameter">new_schema</replaceable>`
	`44`	`+`
	`45`	`+<phrase>where <replaceable class="parameter">domain_constraint</replaceable> is:</phrase>`
	`46`	`+`
	`47`	`+[ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ]`
	`48`	`+{ NOT NULL \| CHECK (<replaceable class="parameter">expression</replaceable>) }`
`44`	`49`	`</synopsis>`
`45`	`50`	`</refsynopsisdiv>`
`46`	`51`
`@@ -79,8 +84,7 @@ ALTER DOMAIN <replaceable class="parameter">name</replaceable>`
`79`	`84`	`<term><literal>ADD <replaceable class="parameter">domain_constraint</replaceable> [ NOT VALID ]</literal></term>`
`80`	`85`	`<listitem>`
`81`	`86`	`<para>`
`82`		`- This form adds a new constraint to a domain using the same syntax as`
`83`		`- <link linkend="sql-createdomain"><command>CREATE DOMAIN</command></link>.`
	`87`	`+ This form adds a new constraint to a domain.`
`84`	`88`	`When a new constraint is added to a domain, all columns using that`
`85`	`89`	`domain will be checked against the newly added constraint. These`
`86`	`90`	`checks can be suppressed by adding the new constraint using the`

Comments

(0)