Document that triggers can break foreign key constraints

4599

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Documentation

Created

2023-10-04 11:54:37

Last modified

2024-05-08 15:16:54 (9 months, 1 week ago)

Latest email

2024-05-08 15:14:18 (9 months, 1 week ago)

Status

2024-07: Committed

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

Target version

Authors

Laurenz Albe (laurenz)

Reviewers

Aleksander Alekseev (a.alekseev), David Johnston (polobo), shihao zhong (zhong950419)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

Trigger violates foreign key constraint: First at 2023-10-02 07:03:33 by Laurenz Albe <laurenz.albe at cybertec.at>
Latest at 2024-05-08 15:14:18 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v4-0001-Document-foreign-key-internals.patch) at 2024-04-07 18:52:23 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v4-0001-Document-foreign-key-internals.patch) at 2024-04-07 18:52:23 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0001-Document-foreign-key-internals.patch) at 2023-12-22 11:39:23 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Document-foreign-key-internals.V2.patch) at 2023-10-31 10:40:38 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Document-foreign-key-internals.patch) at 2023-10-03 07:24:47 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)

History

When	Who	What
2024-05-08 15:16:54	Tom Lane (tgl)	Closed in commitfest 2024-07 with status: Committed
2024-05-08 15:16:54	Tom Lane (tgl)	Changed committer to tgl
2024-04-09 06:27:29	Andrey Borodin (x4m)	Changed targetversion to None
2024-04-09 06:27:23	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:27:19	Andrey Borodin (x4m)	New status: Waiting on Author
2024-02-01 18:11:27	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:01:12	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-16 13:40:35	Aleksander Alekseev (a.alekseev)	New status: Ready for Committer
2023-11-16 13:31:30	Aleksander Alekseev (a.alekseev)	Added a.alekseev as reviewer
2023-10-31 10:42:28	Laurenz Albe (laurenz)	New status: Needs review
2023-10-30 21:52:25	David Johnston (polobo)	New status: Waiting on Author
2023-10-30 21:52:09	David Johnston (polobo)	Added polobo as reviewer
2023-10-30 21:08:55	shihao zhong (zhong950419)	Posted review with messageid <169870013508.94390.6664069465416827376.pgcf@coridan.postgresql.org>
2023-10-30 21:08:55	shihao zhong (zhong950419)	New status: Ready for Committer
2023-10-30 21:03:14	shihao zhong (zhong950419)	Added zhong950419 as reviewer
2023-10-04 11:55:39	Laurenz Albe (laurenz)	Changed authors to Laurenz Albe (laurenz)
2023-10-04 11:55:39	Laurenz Albe (laurenz)	Changed targetversion to 17
2023-10-04 11:54:37	Laurenz Albe (laurenz)	Attached mail thread b81fe38fcc25a81be6e2e5b3fc1ff624130762fa.camel@cybertec.at
2023-10-04 11:54:37	Laurenz Albe (laurenz)	Created patch record