Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement

Philip Alger <paalger0@gmail.com>

From: Philip Alger <paalger0@gmail.com>

To: Josef Šimánek <retro@ballgag.cz>

Cc: jian he <jian.universality@gmail.com>, Jim Jones <jim.jones@uni-muenster.de>, Andrew Dunstan <andrew@dunslane.net>, Cary Huang <cary.huang@highgo.ca>, pgsql-hackers <pgsql-hackers@postgresql.org>, josef.simanek@gmail.com

Date: 2025-11-03T01:18:44Z

Lists: pgsql-hackers

Hi Josef,

Would it make sense to rename trigger related variables to "trig"
> prefix instead of "trg" as is done in other functions in the same file
> (for example in function pg_get_triggerdef)?
>

Not sure it would be the same as triggerdef uses trig, while
triggerdef_worker uses a mix of trig and tg in the same function. It would
be another patch, I believe, to and correct a prefix, then you'd have to
normalize all the other functions within the same file.

-- 
Best,
Phil Alger