Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints

Edit

5554

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch count: 2, First patch: +18−5, All patches: +1101−106

Topic

SQL Commands

Created

2025-02-07 06:27:34

Last modified

2025-04-07 17:53:53 (1 week ago)

Latest email

2025-04-08 00:21:49 (1 week ago)

Status

2025-03: Committed

Target version

Authors

Rushabh Lathia (rlathia)

Reviewers

Become reviewer

Committer

Álvaro Herrera (alvherre)

Links

Emails

Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints: First at 2025-02-06 12:38:46 by Rushabh Lathia <rushabh.lathia at gmail.com>
Latest at 2025-04-08 00:21:49 by Rushabh Lathia <rushabh.lathia at gmail.com>
Latest attachment (v8-0003-not-null-not-valid-miscellous-fix.no-cfbot) at 2025-04-07 12:43:03 from jian he <jian.universality at gmail.com>
    Attachment (v8-0003-not-null-not-valid-miscellous-fix.no-cfbot) at 2025-04-07 12:43:03 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0002-Remove-attnotnullvalid-again.patch) at 2025-04-07 08:28:22 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Allow-NOT-NULL-constraints-to-be-added-as-NOT-VAL.patch) at 2025-04-06 18:02:35 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v7-0002-NOT-NULL-NOT-VALID.patch) at 2025-04-05 07:29:55 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-MergeWithExistingConstraint.patch) at 2025-04-04 11:54:37 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (scratch96.sql) at 2025-04-03 07:45:43 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v6-0001-ensure-pg_dump-table-constraint-info-remain-the-s.patch) at 2025-04-02 13:51:31 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-NOT-NULL-NOT-VALID.patch) at 2025-04-02 11:48:04 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (v6-0001-NOT-NULL-NOT-VALID.patch) at 2025-04-01 20:22:26 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (notnull-notvalid.patch) at 2025-03-27 19:25:40 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v5-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-24 01:27:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-21 14:36:32 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-NOT-NULL-NOT-VALID.patch) at 2025-03-20 14:59:28 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0002-Support-for-pg_dump.patch) at 2025-03-20 09:54:45 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Throw-warning-if-NOT-VALID-is-given-during-CREATE-TA.patch) at 2025-03-17 11:23:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v2-0001-not-null-not-valid-implementation.patch) at 2025-03-17 11:14:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-03-12 10:22:38 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0002-Support-NOT-VALID-and-VALIDATE-CONSTRAINT-for-named-.patch) at 2025-03-11 10:15:46 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0004-Adjust-set_attnotnull-API-input-parameters.patch) at 2025-03-10 11:26:14 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-02-27 09:55:51 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-fixup.patch.txt) at 2025-02-21 06:13:39 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0004-Documentation-and-tab-complete-for-the-NOT-NULL-NOT-.patch) at 2025-02-12 11:22:36 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0001-Convert-pg_attribut.attnotnull-to-char-type.patch) at 2025-02-10 17:18:57 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)
    Attachment (0003-Support-pg_dump-to-dump-NOT-VALID-named-NOT-NULL-con.patch) at 2025-02-06 12:38:46 from Rushabh Lathia <rushabh.lathia at gmail.com> (Patch: Yes)

History

When	Who	What
2025-04-07 17:53:53	Álvaro Herrera (alvherre)	Closed in commitfest 2025-03 with status: Committed
2025-04-02 14:04:38	CFbot	Patch does not need rebase anymore
2025-04-02 12:05:52	CFbot	Patch needs rebase
2025-04-01 21:19:44	CFbot	Patch does not need rebase anymore
2025-03-30 08:32:43	CFbot	Patch needs rebase
2025-03-27 19:39:43	CFbot	Patch does not need rebase anymore
2025-03-27 13:31:52	vigneshwaran C (vignesh.postgres)	New status: Needs review
2025-03-26 23:17:39	CFbot	Patch needs rebase
2025-03-11 10:32:51	CFbot	Patch does not need rebase anymore
2025-03-11 04:15:43	vigneshwaran C (vignesh.postgres)	New status: Waiting on Author
2025-03-10 11:33:32	CFbot	Patch needs rebase
2025-02-07 06:29:01	Rushabh Lathia (rlathia)	Changed authors to Rushabh Lathia (rlathia)
2025-02-07 06:29:01	Rushabh Lathia (rlathia)	Changed committer to alvherre
2025-02-07 06:29:01	Rushabh Lathia (rlathia)	Changed targetversion to 18
2025-02-07 06:27:34	Rushabh Lathia (rlathia)	Attached mail thread CAGPqQf0KitkNack4F5CFkFi-9Dqvp29Ro=EpcWt=4_hs-Rt+bQ@mail.gmail.com
2025-02-07 06:27:34	Rushabh Lathia (rlathia)	Created patch record

Edit