Docs for lock level of ALTER TABLE .. VALIDATE

Started by Simon Riggsover 4 years ago2 messages

Simon Riggs

simon.riggs@enterprisedb.com

over 4 years ago

1 attachment(s)

The docs don't explicitly mention the reduced lock level for this subcommand.

--
Simon Riggs http://www.EnterpriseDB.com/

Attachments:

alter_table_validate_lock_level.patchapplication/octet-stream; name=alter_table_validate_lock_level.patchDownload

diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 39927be41e..f23e704b8c 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -522,6 +522,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>

Alvaro Herrera

alvherre@alvh.no-ip.org

over 4 years ago

In reply to: Simon Riggs (#1)

Re: Docs for lock level of ALTER TABLE .. VALIDATE

On 2021-Apr-22, Simon Riggs wrote:

The docs don't explicitly mention the reduced lock level for this subcommand.

Hmm, true. Pushed to all branches, thanks.

--
ï¿½lvaro Herrera Valdivia, Chile