Hi, Commit 14e87ffa5c543b5f30ead7413084c25f7735039f <https://github.com/postgres/postgres/commit/14e87ffa5c543b5f30ead7413084c25f7735039f> added the support for named NOT NULL constraints. We can now support the NOT VALID/VALID named NOT NULL constraints.
This patch supports the NOT VALID and VALIDATE CONSTRAINT for name NOT NULL constraints. In order to achieve this patch, 1) Converted the pg_attribute.attnotnull to CHAR type, so that it can hold the INVALID flag for the constraint. 2) Added the support for NOT VALID as well as VALIDATE CONSTRAINT support. 3) Support for pg_dump, where we now dumping the INVALID NOT NULL as separate from table schemes, just like CHECK Constraints. 4) Added related testcases. Attaching the patch here. Thanks Alvaro for your offline help and support for this feature. Thanks Rushabh Lathia www.EnterpriseDB.com
0003-Support-pg_dump-to-dump-NOT-VALID-named-NOT-NULL-con.patch
Description: Binary data
0002-Support-NOT-VALID-and-VALIDATE-CONSTRAINT-for-named-.patch
Description: Binary data
0001-Convert-pg_attribut.attnotnull-to-char-type.patch
Description: Binary data
