On Tue, 13 Jul 2021 at 00:14, Matthias van de Meent <boekewurm+postg...@gmail.com> wrote: > Sorry for the delay. I think that covers the basics of what I was > missing in these docs, and although it does not cover the recursive > 'if the check is implied by constraints don't lock this partition', > I'd say that your suggested patch is good enough. Thanks for looking > over this.
Isn't that covered the following? + <para> + Further locks must also be held on all sub-partitions if the table being + attached is itself a partitioned table. Likewise if the default + partition is itself a partitioned table. The locking of the + sub-partitions can be avoided by adding a <literal>CHECK</literal> + constraint as described in + <xref linkend="ddl-partitioning-declarative-maintenance"/>. </para> David