Thread: pgsql: Doc: Clarify lock levels taken during ATTACH PARTITION
Doc: Clarify lock levels taken during ATTACH PARTITION It wasn't all that clear which lock levels, if any, would be held on the DEFAULT partition during an ATTACH PARTITION operation. Also, clarify which locks will be taken if the DEFAULT partition or the table being attached are themselves partitioned tables. Here I'm only backpatching to v12 as before then we obtained an ACCESS EXCLUSIVE lock on the partitioned table. It seems much less relevant to mention which locks are taken on other tables when the partitioned table itself is locked with an ACCESS EXCLUSIVE lock. Author: Matthias van de Meent, David Rowley Discussion: https://postgr.es/m/CAEze2WiTB6iwrV8W_J=fnrnZ7fowW3qu-8iQ8zCHP3FiQ6+o-A@mail.gmail.com Backpatch-through: 12 Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/aa1e9211ecf7ef410b4313f0e061de087aed0aa2 Modified Files -------------- doc/src/sgml/ddl.sgml | 28 +++++++++++++++++++++++++--- doc/src/sgml/ref/alter_table.sgml | 13 +++++++++++-- 2 files changed, 36 insertions(+), 5 deletions(-)