aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlvaro Herrera <alvherre@alvh.no-ip.org>2021-05-06 17:17:56 -0400
committerAlvaro Herrera <alvherre@alvh.no-ip.org>2021-05-06 17:17:56 -0400
commitf518c3df4eb0acc9ad6cb49f98c56f392b76c9c1 (patch)
tree51ff63842514299b83afca5bc6dad8a4993a0e5c
parent082d9d6b576b5bf9f1292dc7150167acfd5e94a5 (diff)
downloadpostgresql-f518c3df4eb0acc9ad6cb49f98c56f392b76c9c1.tar.gz
postgresql-f518c3df4eb0acc9ad6cb49f98c56f392b76c9c1.zip
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 609aeae2576..68ef3e9b4f3 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -506,6 +506,9 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
(See <xref linkend="sql-altertable-notes"/> 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>