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

On Tue, Oct 14, 2025 at 9:14 PM Philip Alger <paalger0(at)gmail(dot)com> wrote:
>
>> select pg_get_trigger_ddl(-1, 'h');
>> ERROR: relation with OID 4294967295 does not exist
>>
>> this error obviously is not good.
>> we can follow the approach used by pg_get_viewdef(oid)
>
> But isn't that an edge case? Would a user really pass in an arbitrary number like -1? That seems counterintuitive.
>

hi.

I complained the same issue for pg_basetype at
https://www.postgresql.org/message-id/3759807.1711658868%40sss.pgh.pa.us

maybe we can return NULL for
select pg_get_trigger_ddl(-1, 'h');