diff options
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index eee1f4bc771..2907afd790d 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -980,20 +980,18 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> A partition using <literal>FOR VALUES</literal> uses same syntax for <replaceable class="parameter">partition_bound_spec</replaceable> as - <link linkend="sql-createtable"><command>CREATE TABLE</command></link>. The partition bound specification + <link linkend="sql-createtable"><command>CREATE TABLE</command></link>. + The partition bound specification must correspond to the partitioning strategy and partition key of the target table. The table to be attached must have all the same columns as the target table and no more; moreover, the column types must also match. Also, it must have all the <literal>NOT NULL</literal> and - <literal>CHECK</literal> constraints of the target table. Currently + <literal>CHECK</literal> constraints of the target table, not marked + <literal>NO INHERIT</literal>. Currently <literal>FOREIGN KEY</literal> constraints are not considered. <literal>UNIQUE</literal> and <literal>PRIMARY KEY</literal> constraints from the parent table will be created in the partition, if they don't already exist. - If any of the <literal>CHECK</literal> constraints of the table being - attached are marked <literal>NO INHERIT</literal>, the command will fail; - such constraints must be recreated without the - <literal>NO INHERIT</literal> clause. </para> <para> |