summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlvaro Herrera2020-05-20 18:35:39 +0000
committerAlvaro Herrera2020-05-20 18:41:00 +0000
commite1218f59ea4c0605e72298fa121d5aef4c66def2 (patch)
tree547ba32ed3c62a95b8467007eb35453d2e50869e
parent39cb2ee09cf900454c1bf14f56048b40c840a490 (diff)
doc: Adding a partition does not require Access Exclusive lock
This doc update was missed in 898e5e3290a7. Backpatch to 12. Pointed out by Pavel Luzanov Discussion: https://postgr.es/m/642e9fbc-b832-698b-9a8f-d626afd7014d@postgrespro.ru
-rw-r--r--doc/src/sgml/ddl.sgml4
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index d4c5ce8d8a7..991323d3471 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -4121,8 +4121,8 @@ ALTER INDEX measurement_city_id_logdate_key
<listitem>
<para>
Some operations require a stronger lock when using declarative
- partitioning than when using table inheritance. For example, adding
- or removing a partition to or from a partitioned table requires taking
+ partitioning than when using table inheritance. For example,
+ removing a partition from a partitioned table requires taking
an <literal>ACCESS EXCLUSIVE</literal> lock on the parent table,
whereas a <literal>SHARE UPDATE EXCLUSIVE</literal> lock is enough
in the case of regular inheritance.