Document that triggers can break foreign key constraints

Title

Topic

Documentation

Created

2023-10-04 11:54:37

Last modified

2024-04-09 06:27:29 (3 weeks ago)

Latest email

2024-04-19 09:16:50 (1 week, 4 days ago)

Status

2024-07: Waiting on Author

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

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-04-19 09:16:50 by Aleksander Alekseev <aleksander at timescale.com>
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-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