diff options
| author | Michael Paquier <michael@paquier.xyz> | 2019-11-05 10:32:38 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2019-11-05 10:32:38 +0900 |
| commit | 2a4d96ebbd65be9aa421a8a4550a51ff12bc6d2d (patch) | |
| tree | acd0169af4e62131813e0321e4ba527fa4d1933b | |
| parent | ea881338014fd5c7d864d78d2eb441d784d1cc39 (diff) | |
| download | postgresql-2a4d96ebbd65be9aa421a8a4550a51ff12bc6d2d.tar.gz postgresql-2a4d96ebbd65be9aa421a8a4550a51ff12bc6d2d.zip | |
Doc: Clarify locks taken when using ALTER TABLE ATTACH PARTITION
Since 898e5e32, this command uses partially ShareUpdateExclusiveLock,
but the docs did not get the call.
Author: Justin Pryzby
Reviewed-by: Amit Langote, Álvaro Herrera, Michael Paquier
Discussion: https://postgr.es/m/20191028001207.GB23808@telsasoft.com
Backpatch-through: 12
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index ea11e652637..8403c797e2e 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -901,6 +901,13 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM the scan of the new partition, it is always skipped when the default partition is a foreign table. </para> + + <para> + Attaching a partition acquires a + <literal>SHARE UPDATE EXCLUSIVE</literal> lock on the parent table, + in addition to <literal>ACCESS EXCLUSIVE</literal> locks on the table + to be attached and on the default partition (if any). + </para> </listitem> </varlistentry> |