Commit9a89f6d

committed

Adjust ALTER TABLE docs on partitioned constraints

Move the "additional restrictions" comment to ALTER TABLE ADDCONSTRAINT instead of ADD CONSTRAINT USING INDEX; and in the latterinstead indicate that partitioned tables are unsupportedNoted by David G. JohnstonDiscussion:https://postgr.es/m/CAKFQuwY4Ld7ecxL_KAmaxwt0FUu5VcPPN2L4dh+3BeYbrdBa5g@mail.gmail.com

1 parent9a44a26 commit9a89f6dCopy full SHA for 9a89f6d

File tree

-2

lines changed

-2

lines changed

Lines changed: 7 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -370,6 +370,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`370`	`370`	`the table, until it is validated by using the <literal>VALIDATE`
`371`	`371`	`CONSTRAINT</literal> option.`
`372`	`372`	`</para>`
	`373`	`+`
	`374`	`+ <para>`
	`375`	`+ Additional restrictions apply when unique or primary key constraints`
	`376`	`+ are added to partitioned tables; see <xref linkend="sql-createtable" />.`
	`377`	`+ </para>`
	`378`	`+`
`373`	`379`	`</listitem>`
`374`	`380`	`</varlistentry>`
`375`	`381`
`@@ -413,8 +419,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`413`	`419`	`</para>`
`414`	`420`
`415`	`421`	`<para>`
`416`		`- Additional restrictions apply when unique or primary key constraints`
`417`		`- are added to partitioned tables; see <xref linkend="sql-createtable" />.`
	`422`	`+ This form is not currently supported on partitioned tables.`
`418`	`423`	`</para>`
`419`	`424`
`420`	`425`	`<note>`

Comments

(0)