Recheck foreign key if a referenced collation was nondeterministic

Edit

ID 4908

Title Recheck foreign key if a referenced collation was nondeterministic

Topic Bug Fixes

Created 2024-03-25 06:49:41

Last modified 2024-11-07 12:17:25 (1 week, 5 days ago)

Latest email 2024-11-19 16:27:26 (2 hours, 59 minutes ago)

Status

2024-11: Needs review

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version 17

Authors Paul Jungwirth (pjungwir)

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

Committer

Links CFbot results (CirrusCI) CFbot GitHub

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-11-19 16:27:26 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-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