Recheck foreign key if a referenced collation was nondeterministic

Title

Topic

Bug Fixes

Created

2024-03-25 06:49:41

Last modified

2024-09-30 19:33:00 (1 week, 2 days ago)

Latest email

2024-09-04 06:54:00 (1 month ago)

Status

2024-11: Needs review

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

Peter Eisentraut (petere)Become reviewer

Committer

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4908
git checkout commitfest/cf/4908

Emails

altering a column's collation leaves an invalid foreign key: First at 2024-03-23 17:04:04 by Paul Jungwirth <pj at illuminatedcomputing.com>
Latest at 2024-09-04 06:54:00 by jian he <jian.universality at gmail.com>
Latest attachment (v5-0001-ensure-PK-FK-ties-related-collation-indeterminist.patch) at 2024-09-04 06:54:00 from jian he <jian.universality at gmail.com>
    Attachment (v5-0001-ensure-PK-FK-ties-related-collation-indeterminist.patch) at 2024-09-04 06:54:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (make_pk_fk_tie_collation_deterministic.diff) at 2024-07-16 08:29:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Revalidate-PK-FK-ties-when-PK-collation-is-change.patch) at 2024-06-07 06:39:15 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-ALTER-COLUMN-SET-DATA-TYPE-Re-check-foreign-key-t.patch) at 2024-04-13 13:13:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Re-check-foreign-key-if-referenced-collation-was-.patch) at 2024-03-25 06:47:26 from Paul Jungwirth <pj at illuminatedcomputing.com> (Patch: Yes)

History

When	Who	What
2024-09-30 19:33:00	Peter Eisentraut (petere)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 05:53:17	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-05-08 09:53:33	Peter Eisentraut (petere)	Added petere as reviewer
2024-03-25 06:50:03	Paul Jungwirth (pjungwir)	Changed authors to Paul Jungwirth (pjungwir)
2024-03-25 06:50:03	Paul Jungwirth (pjungwir)	Changed targetversion to 17
2024-03-25 06:49:41	Paul Jungwirth (pjungwir)	Attached mail thread 78d824e0-b21e-480d-a252-e4b84bc2c24b@illuminatedcomputing.com
2024-03-25 06:49:41	Paul Jungwirth (pjungwir)	Created patch record