diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-02-20 12:08:55 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2018-02-20 12:08:55 -0300 |
| commit | 9a89f6d85467be362f4d426c76439cea70cd327f (patch) | |
| tree | c7dd138494e12cc4acb4191560b3ab918a24e335 | |
| parent | 9a44a26b65d3d36867267624b76d3dea3dc4f6f6 (diff) | |
Adjust ALTER TABLE docs on partitioned constraints
Move the "additional restrictions" comment to ALTER TABLE ADD
CONSTRAINT instead of ADD CONSTRAINT USING INDEX; and in the latter
instead indicate that partitioned tables are unsupported
Noted by David G. Johnston
Discussion: https://postgr.es/m/CAKFQuwY4Ld7ecxL_KAmaxwt0FUu5VcPPN2L4dh+3BeYbrdBa5g@mail.gmail.com
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 5be56d4b287..afe213910c7 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -370,6 +370,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM the table, until it is validated by using the <literal>VALIDATE CONSTRAINT</literal> option. </para> + + <para> + Additional restrictions apply when unique or primary key constraints + are added to partitioned tables; see <xref linkend="sql-createtable" />. + </para> + </listitem> </varlistentry> @@ -413,8 +419,7 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM </para> <para> - Additional restrictions apply when unique or primary key constraints - are added to partitioned tables; see <xref linkend="sql-createtable" />. + This form is not currently supported on partitioned tables. </para> <note> |