Run deferred triggers in the correct security context

ID 4888

Title Run deferred triggers in the correct security context

Topic Bug Fixes

Created 2024-03-06 13:39:38

Last modified 2025-01-23 17:26:40 (1 week, 5 days ago)

Latest email 2025-01-23 18:28:19 (1 week, 5 days ago)

Status

2025-01: Committed

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version 18

Authors Laurenz Albe (laurenz)

Reviewers Pavel Stehule (okbobcz)Become reviewer

Committer Tom Lane (tgl)

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/4888
git checkout commitfest/cf/4888

Emails

Wrong security context for deferred triggers?: First at 2023-11-06 13:23:04 by Laurenz Albe <laurenz.albe at cybertec.at>
Latest at 2025-01-23 18:28:19 by Laurenz Albe <laurenz.albe at cybertec.at>
Latest attachment (v5-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2025-01-23 10:26:57 from Laurenz Albe <laurenz.albe at cybertec.at>
    Attachment (v5-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2025-01-23 10:26:57 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)
    Attachment (reverse-AfterTriggerSharedData-search-order.patch) at 2025-01-22 22:12:41 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v4-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2024-11-04 17:25:51 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)
    Attachment (v3-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2024-10-19 11:02:32 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)
    Attachment (v2-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2024-10-18 13:24:29 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)
    Attachment (v2-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2024-06-22 21:50:14 from Joseph Koshakow <koshy44 at gmail.com> (Patch: No)
    Attachment (v1-0001-Make-AFTER-triggers-run-with-the-correct-user.patch) at 2024-03-06 13:32:06 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: No)

History

When	Who	What
2025-01-23 17:26:40	Tom Lane (tgl)	Closed in commitfest 2025-01 with status: Committed
2025-01-22 00:45:18	Tom Lane (tgl)	Added tgl as committer
2024-12-10 06:28:18	Michael Paquier (michael-kun)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-19 17:13:50	Pavel Stehule (okbobcz)	New status: Ready for Committer
2024-10-04 17:50:31	Andrey Borodin (x4m)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 06:07:22	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-01 14:01:59	Pavel Stehule (okbobcz)	Added okbobcz as reviewer
2024-03-06 13:40:08	Laurenz Albe (laurenz)	Changed authors to Laurenz Albe (laurenz)
2024-03-06 13:40:08	Laurenz Albe (laurenz)	Changed targetversion to 18
2024-03-06 13:39:38	Laurenz Albe (laurenz)	Attached mail thread 77ee784cf248e842f74588418f55c2931e47bd78.camel@cybertec.at
2024-03-06 13:39:38	Laurenz Albe (laurenz)	Created patch record