Re: Check whether a NOT NULL check constraint has been validated

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.