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

On 11/30/25 19:07, Adrian Klaver wrote: 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_constrain

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

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 l

Check whether a NOT NULL check constraint has been validated

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) does