What about SET NOT NULL constraints? There is no VALIDATE CONSTRAINT for it.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных