summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlvaro Herrera2021-05-06 21:17:56 +0000
committerAlvaro Herrera2021-05-06 21:17:56 +0000
commitf760137d441b10fea341fc1af8bb982db88c9d9f (patch)
treeadbae58b8c5da85d3786dc8045099e7ec48ba966
parent8f65db5ecf9ba235f2b5804ab6c788a310e31452 (diff)
Document lock level used by ALTER TABLE VALIDATE CONSTRAINT
Backpatch all the way back to 9.6. Author: Simon Riggs <simon.riggs@enterprisedb.com> Discussion: https://postgr.es/m/CANbhV-EwxvdhHuOLdfG2ciYrHOHXV=mm6=fD5aMhqcH09Li3Tg@mail.gmail.com
-rw-r--r--doc/src/sgml/ref/alter_table.sgml3
1 files changed, 3 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 56e134d82a5..f509a35367c 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -369,6 +369,9 @@ ALTER TABLE ALL IN TABLESPACE <replaceable class="PARAMETER">name</replaceable>
endterm="sql-altertable-notes-title"> below for an explanation of the
usefulness of this command.)
</para>
+ <para>
+ This command acquires a <literal>SHARE UPDATE EXCLUSIVE</literal> lock.
+ </para>
</listitem>
</varlistentry>