diff options
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 9 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 4 |
2 files changed, 9 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 606e0be8a90..8dfed4f557b 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -849,7 +849,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM Note that if the existing table is a foreign table, it is currently not allowed to attach the table as a partition of the target table if there are <literal>UNIQUE</literal> indexes on the target table. (See also - <xref linkend="sql-createforeigntable"/>.) + <xref linkend="sql-createforeigntable"/>.) For each user-defined + row-level trigger that exists in the target table, a corresponding one + is created in the attached table. </para> <para> @@ -918,10 +920,11 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <term><literal>DETACH PARTITION</literal> <replaceable class="parameter">partition_name</replaceable></term> <listitem> <para> - This form detaches specified partition of the target table. The detached + This form detaches the specified partition of the target table. The detached partition continues to exist as a standalone table, but no longer has any ties to the table from which it was detached. Any indexes that were - attached to the target table's indexes are detached. + attached to the target table's indexes are detached. Any triggers that + were created as clones of those in the target table are removed. </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 8b0dd50d365..d6f9f21c2bf 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -399,7 +399,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM Creates the table as a <firstterm>partition</firstterm> of the specified parent table. The table can be created either as a partition for specific values using <literal>FOR VALUES</literal> or as a default partition - using <literal>DEFAULT</literal>. + using <literal>DEFAULT</literal>. Any indexes, constraints and + user-defined row-level triggers that exist in the parent table are cloned + on the new partition. </para> <para> |