diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-04-21 17:14:18 -0400 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-04-21 17:14:18 -0400 |
| commit | 97dcd5cd1500184903ae66ea9629efb04e4da0b9 (patch) | |
| tree | 55bd3a8a5c40ad9ae115e92a1b9fa3604bf33fe7 | |
| parent | 56259c377f4a70c967aa6812bb09ee64642acd8f (diff) | |
| download | postgresql-97dcd5cd1500184903ae66ea9629efb04e4da0b9.tar.gz postgresql-97dcd5cd1500184903ae66ea9629efb04e4da0b9.zip | |
Document partitiong tables ancillary object handling some more
Add a couple of lines to make it explicit that indexes, constraints,
triggers are added, removed, or left alone.
Backpatch to pg11.
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Reviewed-by: Justin Pryzby <pryzby@telsasoft.com>
Discussion: https://postgr.es/m/20200421162038.GA18628@alvherre.pgsql
| -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 261d526f0b0..b0e341bf202 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -864,7 +864,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> @@ -926,10 +928,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 0b9c46ce23d..b9e178834b0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -397,7 +397,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> |