Recheck foreign key if a referenced collation was nondeterministic

Edit
ID 4908
Title Recheck foreign key if a referenced collation was nondeterministic
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Bug Fixes
Tags
Created 2024-03-25 06:49:41
Last modified 2024-12-02 07:42:58 (10 months ago)
Latest email 2024-11-30 07:44:54 (10 months ago)
Status
2024-11 (2024-11-01 – 2024-11-30): Committed
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
Target version 18
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
Edit