Check for Unvalidated Database Constraints

Check for Unvalidated Database Constraints

October 10, 2023

I am not sure who I saw this on Mastodon but it was something that is quick and easy to check. Use the following:

select conrelid::regclass
      ,conname
  from pg_constraint
 where not convalidated

Nothing should be returned but if there is you know if a constraint was created without validation.