Commitd655614

committed

Improve documentation of how NOT NULL works with partitioning.

1 parent4785e37 commitd655614Copy full SHA for d655614

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -175,9 +175,14 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable>`
`175`	`175`	`</para>`
`176`	`176`
`177`	`177`	`<para>`
`178`		`- If this table is a partition, one cannot perform <literal>DROP NOT NULL</>`
	`178`	`+ If this table is a partition, one cannot perform <literal>DROP NOT NULL</literal>`
`179`	`179`	`on a column if it is marked <literal>NOT NULL</literal> in the parent`
`180`		`- table.`
	`180`	`+ table. To drop the <literal>NOT NULL</literal> constraint from all the`
	`181`	`+ partitions, perform <literal>DROP NOT NULL</literal> on the parent`
	`182`	`+ table. Even if there is no <literal>NOT NULL</> constraint on the`
	`183`	`+ parent, such a constraint can still be added to individual partitions,`
	`184`	`+ if desired; that is, the children can disallow nulls even if the parent`
	`185`	`+ allows them, but not the other way around.`
`181`	`186`	`</para>`
`182`	`187`	`</listitem>`
`183`	`188`	`</varlistentry>`

Comments

(0)