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

Commit20a562f

Browse files
Fix docs on lock level for ALTER TABLE VALIDATE
ALTER TABLE .. VALIDATE CONSTRAINT previouslygave incorrect details about lock levels andtherefore incomplete reasons to use the option.Initial bug report and fix from Marko TiikkajaReworded by me to include comments by Kevin Grittner
1 parent25f5487 commit20a562f

File tree

1 file changed

+7
-3
lines changed

1 file changed

+7
-3
lines changed

‎doc/src/sgml/ref/alter_table.sgml

Lines changed: 7 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -326,9 +326,13 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable>
326326
as <literal>NOT VALID</literal>, by scanning the table to ensure there
327327
are no rows for which the constraint is not satisfied.
328328
Nothing happens if the constraint is already marked valid.
329-
The value of separating validation from initial creation of the
330-
constraint is that validation requires a lesser lock on the table
331-
than constraint creation does.
329+
</para>
330+
<para>
331+
Validation can be a long process on larger tables and currently requires
332+
an <literal>ACCESS EXCLUSIVE</literal> lock. The value of separating
333+
validation from initial creation is that you can defer validation to less
334+
busy times, or can be used to give additional time to correct pre-existing
335+
errors while preventing new errors.
332336
</para>
333337
</listitem>
334338
</varlistentry>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp