MIME-Version: 1.0
From: Stuart Campbell <stuart.campbell@ridewithvia.com>
Date: Mon, 1 Dec 2025 11:59:07 +1100
Message-ID: <CAAZ6SnyOmabkioC3n8GCk5dWQsx57pCSiZy_x1JEOrY7aejxaA@mail.gmail.com>
Subject: Check whether a NOT NULL check constraint has been validated
To: pgsql-general@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002175b60644d97dca"
Archived-At: <https://www.postgresql.org/message-id/CAAZ6SnyOmabkioC3n8GCk5dWQsx57pCSiZy_x1JEOrY7aejxaA%40mail.gmail.com>
Precedence: bulk

--0000000000002175b60644d97dca
Content-Type: text/plain; charset="UTF-8"

Hello,

I have several NOT NULL check constraints in my schema that were originally
added as NOT VALID. I would like to determine whether they have all since
been validated, or not.

I thought maybe pg_constraint.convalidated might help, but it seems like
the version of Postgres I'm using (16) doesn't store not null constraints
in that table. And even in later versions, maybe it doesn't hold the
information I need.

Is there another way to discover this?

-- 
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.


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

<div dir=3D"ltr"><div>Hello,</div><div><br></div><div>I have several NOT NU=
LL check constraints in my schema that were originally added as NOT VALID. =
I would like to determine whether they have all since been validated, or no=
t.</div><div><br></div><div>I thought maybe pg_constraint.convalidated migh=
t help, but it seems like the version of Postgres I&#39;m using (16) doesn&=
#39;t store not null constraints in that table. And even in later versions,=
 maybe it doesn&#39;t hold the information I need.</div><div><br></div><div=
>Is there another way to discover this?</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>
--0000000000002175b60644d97dca--