MIME-Version: 1.0
From: "Pete O'Such" <posuch@gmail.com>
Date: Thu, 18 Jun 2026 00:15:13 -0400
Message-ID: 
 <CAEdngj81QMQ=_a0DKhX+iUomLE=iPr3X598Pr1O=JyJs0s00Jw@mail.gmail.com>
Subject: Doc error re: "not null" "not valid"
To: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e0038906547f6c20"
Archived-At: 
 <https://www.postgresql.org/message-id/CAEdngj81QMQ%3D_a0DKhX%2BiUomLE%3DiPr3X598Pr1O%3DJyJs0s00Jw%40mail.gmail.com>
Precedence: bulk

--000000000000e0038906547f6c20
Content-Type: text/plain; charset="UTF-8"

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

--000000000000e0038906547f6c20
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><a href=3D"https://www.postgresql.org/docs/9.1/sql-al=
tertable.html">https://www.postgresql.org/docs/9.1/sql-altertable.html</a><=
/div><div><br></div><div>The text for &quot;ADD table_constraint&quot; says=
 that NOT VALID &quot;is currently only allowed for foreign key
        constraints.&quot; Testing with 18.4 shows that this is incorrect. =
A brief example of it working for a NOT NULL constraint is available here:<=
br><a href=3D"https://neon.com/postgresql/18/not-null-as-not-valid">https:/=
/neon.com/postgresql/18/not-null-as-not-valid</a></div><div><br></div><div>=
It looks like this is correctly noted as working in the 18.0 release notes =
(=C2=A0<a href=3D"https://www.postgresql.org/docs/release/18.0/">https://ww=
w.postgresql.org/docs/release/18.0/</a>=C2=A0), but not in the main docs.</=
div><div><br></div><div>Thank you!</div><div><br></div><div>-Pete O&#39;Suc=
h</div></div>

--000000000000e0038906547f6c20--