Recheck foreign key if a referenced collation was nondeterministic

4908

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2024-03-25 06:49:41

Last modified

2024-12-02 07:42:58 (3 months, 1 week ago)

Latest email

2024-11-30 07:44:54 (3 months, 1 week ago)

Status

2024-11: Committed

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version

Authors

Paul Jungwirth (pjungwir)

Reviewers

Peter Eisentraut (petere), Jian He (stayreal)Become reviewer

Committer

Peter Eisentraut (petere)

Links

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-11-30 07:44:54 by Peter Eisentraut <peter at eisentraut.org>
Latest attachment (0001-Fix-error-code-for-referential-action-RESTRICT.patch) at 2024-11-19 16:27:26 from Peter Eisentraut <peter at eisentraut.org>
    Attachment (0001-Fix-error-code-for-referential-action-RESTRICT.patch) at 2024-11-19 16:27:26 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (v8-0001-add-more-tests-for-pk-fk-tie-with-nondetermin.no-cfbot1) at 2024-11-14 02:21:16 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0001-add-more-tests-for-pk-fk-tie-with-nondetermini.no-cfbot) at 2024-11-13 12:56:59 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Fix-collation-handling-for-foreign-keys.patch) at 2024-11-07 12:09:53 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    Attachment (pk_fk_inderministic_collation.sql) at 2024-10-25 06:23:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v6-0001-Fix-collation-handling-for-foreign-keys.patch) at 2024-10-17 11:14:11 from Peter Eisentraut <peter at eisentraut.org> (Patch: Yes)
    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-12-02 07:42:58	Peter Eisentraut (petere)	Closed in commitfest 2024-11 with status: Committed
2024-12-02 07:42:58	Peter Eisentraut (petere)	Changed committer to petere
2024-11-28 11:32:25	Kirill Reshke (reshke)	Changed targetversion to 18
2024-11-07 12:17:25	Peter Eisentraut (petere)	Changed reviewers to Peter Eisentraut (petere), Jian He (stayreal)
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