Fix not reset pg_attribute.attnotnull when PK drop indirectly

Title

Topic

Bug Fixes

Created

2024-04-02 12:47:50

Last modified

2024-04-23 09:02:05 (1 week, 1 day ago)

Latest email

2024-04-19 10:40:11 (1 week, 5 days ago)

Status

2024-07: Committed

Target version

Authors

Tender Wang (tndrwang)

Reviewers

Álvaro Herrera (alvherre), jian he (universality)Become reviewer

Committer

Álvaro Herrera (alvherre)

Links

Emails

Can't find not null constraint, but \d+ shows that: First at 2024-03-26 12:00:36 by Tender Wang <tndrwang at gmail.com>
Latest at 2024-04-19 10:40:11 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v2-0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-18 18:49:52 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (v2-0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-18 18:49:52 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Better-handle-indirect-constraint-drops.patch) at 2024-04-11 14:48:00 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v2-0001-Handle-ALTER-.-DROP-NOT-NULL-when-no-pg_constrain.patch) at 2024-04-10 17:23:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v1-0001-minor-coesmetuic-refactor-in-dropconstraint_inter.patch) at 2024-04-10 15:03:30 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (0001-Handle-ALTER-.-DROP-NOT-NULL-when-no-pg_constraint-r.patch) at 2024-04-10 13:58:49 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Correctly-reset-attnotnull-when-constraints-dropped-.patch) at 2024-04-09 17:29:03 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v4-0001-Fix-pg_attribute-attnotnull-not-reset-when-droppe.patch) at 2024-03-28 12:05:04 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-pg_attribute-attnotnull-not-reset-when-droppe.patch) at 2024-03-27 14:26:10 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-attnotnull-not-correct-reset-issue.patch) at 2024-03-26 12:00:36 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)

History

When	Who	What
2024-04-23 09:02:05	Tender Wang (tndrwang)	Closed in commitfest 2024-07 with status: Committed
2024-04-23 09:02:05	Tender Wang (tndrwang)	Changed committer to alvherre
2024-04-02 12:48:50	Tender Wang (tndrwang)	Changed reviewers to Álvaro Herrera (alvherre), jian he (universality)
2024-04-02 12:48:50	Tender Wang (tndrwang)	Changed authors to Tender Wang (tndrwang)
2024-04-02 12:47:50	Tender Wang (tndrwang)	Attached mail thread CAHewXN=hMbNa3d43NOR=OCgdgpTt18S-1fmueCoEGesyeK4bqw@mail.gmail.com
2024-04-02 12:47:50	Tender Wang (tndrwang)	Created patch record