Check whether a NOT NULL check constraint has been validated

From: Stuart Campbell <stuart(dot)campbell(at)ridewithvia(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Check whether a NOT NULL check constraint has been validated
Date: 2025-12-01 00:59:07
Message-ID: CAAZ6SnyOmabkioC3n8GCk5dWQsx57pCSiZy_x1JEOrY7aejxaA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-12-01 03:07:47 Re: Check whether a NOT NULL check constraint has been validated
Previous Message Adrian Klaver 2025-11-29 17:56:31 Re: How to use index in simple select