Horton

Thread

  1. Doc error re: "not null" "not valid"

    Pete O'Such <posuch@gmail.com> — 2026-06-18T04:15:13Z

    https://www.postgresql.org/docs/9.1/sql-altertable.html

The text for "ADD table_constraint" says that NOT VALID "is currently only
allowed for foreign key constraints." Testing with 18.4 shows that this is
incorrect. A brief example of it working for a NOT NULL constraint is
available here:
https://neon.com/postgresql/18/not-null-as-not-valid

It looks like this is correctly noted as working in the 18.0 release notes
( https://www.postgresql.org/docs/release/18.0/ ), but not in the main docs.

Thank you!

-Pete O'Such

  2. Re: Doc error re: "not null" "not valid"

    David G. Johnston <david.g.johnston@gmail.com> — 2026-06-18T04:26:31Z

    On Wednesday, June 17, 2026, Pete O'Such <posuch@gmail.com> wrote:

> https://www.postgresql.org/docs/9.1/sql-altertable.html
>
> The text for "ADD table_constraint" says that NOT VALID "is currently only
> allowed for foreign key constraints."
>
>
You are commenting on version 9.1 documentation but testing version 18.
The 18 docs mention not-null constraints.

David J.

  3. Re: Doc error re: "not null" "not valid"

    Pete O'Such <posuch@gmail.com> — 2026-06-18T04:45:46Z

    >
> You are commenting on version 9.1 documentation but testing version 18.
> The 18 docs mention not-null constraints.


That's totally right. Thanks for setting me straight.

Pete

On Thu, Jun 18, 2026 at 12:26 AM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Wednesday, June 17, 2026, Pete O'Such <posuch@gmail.com> wrote:
>
>> https://www.postgresql.org/docs/9.1/sql-altertable.html
>>
>> The text for "ADD table_constraint" says that NOT VALID "is currently
>> only allowed for foreign key constraints."
>>
>>
> You are commenting on version 9.1 documentation but testing version 18.
> The 18 docs mention not-null constraints.
>
> David J.
>
>