Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commite2a19a6

Browse files
committed
doc: Adding a partition does not require Access Exclusive lock
This doc update was missed in898e5e3. Backpatch to 12.Pointed out by Pavel LuzanovDiscussion:https://postgr.es/m/642e9fbc-b832-698b-9a8f-d626afd7014d@postgrespro.ru
1 parentfd76369 commite2a19a6

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-
orremoving 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)

[8]ページ先頭

©2009-2025 Movatter.jp