diff options
| author | Álvaro Herrera | 2024-11-07 13:06:24 +0000 |
|---|---|---|
| committer | Álvaro Herrera | 2024-11-07 13:06:24 +0000 |
| commit | 477830c1cb94beeb0440629820ef916c59beabb6 (patch) | |
| tree | 61fe1d5e97201f12fcad2ffd5db060f8391b5bd7 | |
| parent | 50c1453a308dc535255a0048fce7cfdb0fc5219d (diff) | |
doc: Reword ALTER TABLE ATTACH restriction on NO INHERIT constraints
The previous wording is easy to read incorrectly; this change makes it
simpler, less ambiguous, and less prominent.
Backpatch to all live branches.
Reviewed-by: Amit Langote <amitlangote09@gmail.com>
Discussion: https://postgr.es/m/202411051201.zody6mld7vkw@alvherre.pgsql
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 7 |
1 files changed, 2 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 39df9d374fb..882e15f04ca 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -901,15 +901,12 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM 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> |