Skip to content

Commit e2a19a6

Browse files
committed
doc: Adding a partition does not require Access Exclusive lock
This doc update was missed in 898e5e3. Backpatch to 12. Pointed out by Pavel Luzanov Discussion: https://postgr.es/m/642e9fbc-b832-698b-9a8f-d626afd7014d@postgrespro.ru
1 parent fd76369 commit e2a19a6

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

doc/src/sgml/ddl.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4115,8 +4115,8 @@ ALTER INDEX measurement_city_id_logdate_key
41154115
<listitem>
41164116
<para>
41174117
Some operations require a stronger lock when using declarative
4118-
partitioning than when using table inheritance. For example, adding
4119-
or removing a partition to or from a partitioned table requires taking
4118+
partitioning than when using table inheritance. For example,
4119+
removing a partition from a partitioned table requires taking
41204120
an <literal>ACCESS EXCLUSIVE</literal> lock on the parent table,
41214121
whereas a <literal>SHARE UPDATE EXCLUSIVE</literal> lock is enough
41224122
in the case of regular inheritance.

0 commit comments

Comments
 (0)