Doc error re: "not null" "not valid" - Mailing list pgsql-docs

From Pete O'Such
Subject Doc error re: "not null" "not valid"
Date
Msg-id CAEdngj81QMQ=_a0DKhX+iUomLE=iPr3X598Pr1O=JyJs0s00Jw@mail.gmail.com
Whole thread
Responses Re: Doc error re: "not null" "not valid"
List pgsql-docs

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

pgsql-docs by date:

Previous
From: Christoph Berg
Date:
Subject: Re: 7.2.1. The FROM Clause
Next
From: "David G. Johnston"
Date:
Subject: Re: Doc error re: "not null" "not valid"