MIME-Version: 1.0
References: <CAAZ6SnyOmabkioC3n8GCk5dWQsx57pCSiZy_x1JEOrY7aejxaA@mail.gmail.com>
 <1b930bcc-16f4-4c97-93f8-a21d314ba373@aklaver.com> <301832e8-a3d7-46f5-9db5-691b71eee9ac@aklaver.com>
In-Reply-To: <301832e8-a3d7-46f5-9db5-691b71eee9ac@aklaver.com>
From: Stuart Campbell <stuart.campbell@ridewithvia.com>
Date: Mon, 1 Dec 2025 22:02:00 +1100
Message-ID: <CAAZ6SnyOHAcMHwAhj4fYUN2jp8FMQzSgTotifRG8Rz4tpGEMWQ@mail.gmail.com>
Subject: Re: Check whether a NOT NULL check constraint has been validated
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000030a0db0644e1e9e4"
Archived-At: <https://www.postgresql.org/message-id/CAAZ6SnyOHAcMHwAhj4fYUN2jp8FMQzSgTotifRG8Rz4tpGEMWQ%40mail.gmail.com>
Precedence: bulk

--00000000000030a0db0644e1e9e4
Content-Type: text/plain; charset="UTF-8"

Hi Adrian,


> Now I am not sure what you did.
>
> Are you saying you used a CHECK constraint to check for NULL values?


That's right. Something like:

  ALTER TABLE foo ADD CONSTRAINT bar_not_null CHECK (bar IS NOT NULL) NOT
VALID


> If so then pg_constraint.convalidated would work.


You're right. I didn't immediately find what I was looking for, and when I
looked at the docs for pg_constraints, I guess I confused myself with this
comment:

> Not-null constraints are represented in the pg_attribute
<https://www.postgresql.org/docs/16/catalog-pg-attribute.html> catalog, not
here.

Thanks for the assistance.

-- 
This communication and any attachments may contain confidential information 
and are intended to be viewed only by the intended recipients. If you have 
received this message in error, please notify the sender immediately by 
replying to the original message and then delete all copies of the email 
from your systems.


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

<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><div>Hi A=
drian,</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex">
Now I am not sure what you did.<br>
<br>
Are you saying you used a CHECK constraint to check for NULL values?</block=
quote><div><br></div><div>That&#39;s right. Something like:</div><div><br><=
/div><div>=C2=A0 <span style=3D"font-family:monospace">ALTER TABLE foo ADD =
CONSTRAINT bar_not_null CHECK (bar IS NOT NULL) NOT VALID</span>=C2=A0</div=
><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px=
 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
If so then pg_constraint.convalidated would work.</blockquote><div><br></di=
v><div>You&#39;re right. I didn&#39;t immediately find what I was looking f=
or, and when I looked at the docs for pg_constraints, I guess I confused my=
self with this comment:</div><div><br></div><div>&gt;=C2=A0Not-null constra=
ints are represented in the <a class=3D"gmail-link" href=3D"https://www.pos=
tgresql.org/docs/16/catalog-pg-attribute.html" title=3D"53.7.=C2=A0pg_attri=
bute"><code class=3D"gmail-structname">pg_attribute</code></a> catalog, not=
 here.</div><div>=C2=A0</div>Thanks for the assistance.</div></div>

<br>
<div>This communication and any attachments may contain confidential inform=
ation and are intended to be viewed only by the intended recipients. If you=
 have received this message in error, please notify the sender immediately =
by replying to the original message and then delete all copies of the email=
 from your systems.</div><div><br></div><div><br></div>
--00000000000030a0db0644e1e9e4--