Re: doc pg_constraint.convalidated column description need update
jian he <jian.universality@gmail.com>
From: jian he <jian.universality@gmail.com>
To: Robert Treat <rob@xzilla.net>
Cc: Peter Eisentraut <peter@eisentraut.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-06-09T03:59:34Z
Lists: pgsql-hackers
On Thu, Jun 5, 2025 at 4:47 AM Robert Treat <rob@xzilla.net> wrote:
>
> I think some of those changes are worth a second stab, so here is an
> updated patch which removes the ancillary tagging and corresponding
> line wrappings and focuses just on the wording/grammer improvements;
> hopefully it will be easier to make sense of.
>
hi.
<para>
- 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 <command>ALTER TABLE ADD CONSTRAINT</command> command is
committed. The main purpose of the <literal>NOT VALID</literal>
here, it should be "not-null constraints"?
Other than that, it looks good to me
Commits
-
doc: Some copy-editing around constraint validation and enforcement
- 62a47aea1d8d 18.0 landed
-
doc: Update description of pg_constraint.convalidated
- 30c15987d9b7 18.0 landed