diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index d63f3a621ac..dc02d6d8b58 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -461,7 +461,7 @@ WITH ( MODULUS numeric_literal, REM
This form adds a new constraint to a table using the same constraint
syntax as CREATE TABLE, plus the option NOT
VALID, which is currently only allowed for foreign key,
- CHECK constraints and not-null constraints.
+ CHECK, and not-null constraints.
@@ -469,7 +469,7 @@ WITH ( MODULUS numeric_literal, REM
existing rows in the table satisfy the new constraint. But if
the NOT VALID option is used, this
potentially-lengthy scan is skipped. The constraint will still be
- enforced against subsequent inserts or updates (that is, they'll fail
+ applied against subsequent inserts or updates (that is, they'll fail
unless there is a matching row in the referenced table, in the case
of foreign keys, or they'll fail unless the new row matches the
specified check condition). But the
@@ -591,7 +591,7 @@ WITH ( MODULUS numeric_literal, REM
This form validates a foreign key, check, or not-null constraint that was
previously created as NOT VALID, by scanning the
table to ensure there are no rows for which the constraint is not
- satisfied. If the constraint is not enforced, an error is thrown.
+ satisfied. If the constraint was created as NOT ENFORCED, an error is thrown.
Nothing happens if the constraint is already marked valid.
(See below for an explanation
of the usefulness of this command.)
@@ -1466,11 +1466,11 @@ WITH ( MODULUS numeric_literal, REM
- Adding an enforced CHECK or NOT NULL
+ Adding a CHECK or NOT NULL
constraint requires scanning the table to verify that existing rows meet the
constraint, but does not require a table rewrite. If a CHECK
- constraint is added as NOT ENFORCED, the validation will
- not be performed.
+ constraint is added as NOT ENFORCED, no verification will
+ be performed.
@@ -1485,7 +1485,7 @@ WITH ( MODULUS numeric_literal, REM
- Scanning a large table to verify a new foreign key or check constraint
+ Scanning a large table to verify new foreign key, check, or not null constraints
can take a long time, and other updates to the table are locked out
until the ALTER TABLE ADD CONSTRAINT command is
committed. The main purpose of the NOT VALID