On 11/30/25 16:59, Stuart Campbell wrote:
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?
1) Select count(*) from <table> where <col> IS NULL;
2) From here
https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-NOTES
ALTER TABLE <table> VALIDATE CONSTRAINT <constraint_name>;
As described:
". Once the constraint is in place, no new violations can be inserted,
and the existing problems can be corrected at leisure until VALIDATE
CONSTRAINT finally succeeds."
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.
--
Adrian Klaver
[email protected]
