Check whether a NOT NULL check constraint has been validated - Mailing list pgsql-general

From Stuart Campbell
Subject Check whether a NOT NULL check constraint has been validated
Date
Msg-id CAAZ6SnyOmabkioC3n8GCk5dWQsx57pCSiZy_x1JEOrY7aejxaA@mail.gmail.com
Whole thread Raw
Responses Re: Check whether a NOT NULL check constraint has been validated
List 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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to use index in simple select
Next
From: Adrian Klaver
Date:
Subject: Re: Check whether a NOT NULL check constraint has been validated