Re: DETACH PARTITION and FOR EACH ROW triggers on partitioned tables
Justin Pryzby <pryzby@telsasoft.com>
From: Justin Pryzby <pryzby@telsasoft.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Amit Langote <amitlangote09@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@lists.postgresql.org
Date: 2020-04-21T16:45:10Z
Lists: pgsql-hackers
On Tue, Apr 21, 2020 at 12:20:38PM -0400, Alvaro Herrera wrote: > diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml > index 7595e609b5..233905552c 100644 > --- a/doc/src/sgml/ref/alter_table.sgml > +++ b/doc/src/sgml/ref/alter_table.sgml > @@ -941,13 +943,14 @@ 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 > 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 to mirror those in the target table are removed. Can you say "cloned" here instead of mirror ? > + attached to the target table's indexes are detached. Any triggers that > + were created as clones of triggers in the target table are removed. Also, I see in the surrounding context a missing word? This form detaches THE specified partition of the target table. -- Justin
Commits
-
psql \d: Display table where trigger is defined, if inherited
- c33869cc3bfc 13.0 landed
-
Document partitiong tables ancillary object handling some more
- cda02408f20d 12.3 landed
- 97dcd5cd1500 11.8 landed
- 8803506c411e 13.0 landed
-
Fix detaching partitions with cloned row triggers
- e26c8a6b31e9 12.3 landed
- afccd76f1cce 13.0 landed
- 0b83c47216b0 11.8 landed