Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement

Edit
ID 6131
Title Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 1, First patch: +371−4, All patches: +371−4
Tags Good First Review My First Patch
Created 2025-10-14 02:01:32
Last modified 2026-08-01 00:00:09 (11 hours ago)
Latest email 2026-07-20 16:21:38 (1 week ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Ready for Committer
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version 19
Authors Phil Alger (paalger)
Reviewers Josef Šimánek (retro), Jim Jones (jimus), Soumya S Murali (soumyamurali) Become reviewer
Committer
Links Git
Emails
[PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
First at 2025-10-14 01:59:18 by Philip Alger <paalger0 at gmail.com>
Latest at 2026-07-20 16:21:38 by Marcos Pegoraro <marcos at f10.com.br>
Latest attachment (v9-0001-Add-pg_get_trigger_ddl-function.patch) at 2026-07-17 12:47:45 from Philip Alger <paalger0 at gmail.com>
    Attachment (v9-0001-Add-pg_get_trigger_ddl-function.patch) at 2026-07-17 12:47:45 from Philip Alger <paalger0 at gmail.com> (Patch: No)
    Attachment (v8-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-22 22:27:19 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-18 21:34:59 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-18 04:08:13 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-16 19:04:56 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-15 21:25:14 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-14 21:29:46 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-14 04:03:13 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-pg_get_trigger_ddl-function.patch) at 2025-10-14 01:59:18 from Philip Alger <paalger0 at gmail.com> (Patch: Yes)
History
When Who What
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-05-02 12:42:31 Soumya S Murali (soumyamurali) Added soumyamurali as reviewer
2026-04-05 14:58:06 Andrew Dunstan (adunstan) Moved from CF PG19-Final to CF PG20-1
2026-02-10 11:10:36 Jim Jones (jimus) Moved from CF PG19-4 to CF PG19-Final
2025-12-16 01:00:27 Phil Alger (paalger) Moved from CF PG19-3 to CF PG19-4
2025-11-02 21:06:25 Josef Šimánek (retro) Added retro as reviewer
2025-11-02 21:06:06 Josef Šimánek (retro) Removed retro from reviewers
2025-11-02 19:29:56 Josef Šimánek (retro) Added retro as reviewer
2025-10-31 01:19:24 Phil Alger (paalger) Changed topic to Server Features
2025-10-21 22:22:35 Jim Jones (jimus) New status: Ready for Committer
2025-10-16 08:48:00 Jim Jones (jimus) Added jimus as reviewer
2025-10-14 02:02:05 Phil Alger (paalger) Changed gitlink to https://github.com/drpalaric/postgres/tree/dev/trigger/PG-152
2025-10-14 02:01:33 Phil Alger (paalger) Attached mail thread CAPXBC8K5awmtMoq66DGHe+nD7hUf6HPRVHLeGNBRpCDpzusOXQ@mail.gmail.com
2025-10-14 02:01:32 Phil Alger (paalger) Created patch record
Edit