MIME-Version: 1.0
References: 
 <CAEdngj81QMQ=_a0DKhX+iUomLE=iPr3X598Pr1O=JyJs0s00Jw@mail.gmail.com>
 <CAKFQuwYNc=B_oZST+NHuRzz2hQ6SYaR9XTL78CwNzrCyjrheLw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwYNc=B_oZST+NHuRzz2hQ6SYaR9XTL78CwNzrCyjrheLw@mail.gmail.com>
From: "Pete O'Such" <posuch@gmail.com>
Date: Thu, 18 Jun 2026 00:45:46 -0400
Message-ID: 
 <CAEdngj9jJ=5j=AFaK5igX96sNomDcSVp2H--8JZmcg7XoXyyTQ@mail.gmail.com>
Subject: Re: Doc error re: "not null" "not valid"
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004831dc06547fda92"
Archived-At: 
 <https://www.postgresql.org/message-id/CAEdngj9jJ%3D5j%3DAFaK5igX96sNomDcSVp2H--8JZmcg7XoXyyTQ%40mail.gmail.com>
Precedence: bulk

--0000000000004831dc06547fda92
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

>
> 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=E2=80=AFAM 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.
>
>

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

<div dir=3D"ltr"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">You are =
commenting on version 9.1 documentation but testing version 18.=C2=A0 The 1=
8 docs mention not-null constraints.</blockquote><div><br></div><div>That&#=
39;s totally right. Thanks for setting me straight.</div><div><br></div><di=
v>Pete=C2=A0</div></div><br><div class=3D"gmail_quote gmail_quote_container=
"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Jun 18, 2026 at 12:26=E2=80=
=AFAM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">d=
avid.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,20=
4,204);padding-left:1ex">On Wednesday, June 17, 2026, Pete O&#39;Such &lt;<=
a href=3D"mailto:posuch@gmail.com" target=3D"_blank">posuch@gmail.com</a>&g=
t; wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"=
ltr"><div><a href=3D"https://www.postgresql.org/docs/9.1/sql-altertable.htm=
l" target=3D"_blank">https://www.postgresql.org/docs/9.1/sql-altertable.htm=
l</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;</div><div><br></div></div></blockquote><div><br>=
</div><div>You are commenting on version 9.1 documentation but testing vers=
ion 18.=C2=A0 The 18 docs mention not-null constraints.</div><div>=C2=A0</d=
iv><div>David J.</div><div><br></div>
</blockquote></div>

--0000000000004831dc06547fda92--