Request a Demo
Home   >   mailing lists

Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement - Mailing list pgsql-hackers

From jian he
Subject Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Date
Msg-id CACJufxGbE4uJWu1YuqdmOx+7PMBpHvX_fbRMmHu=r4SrsuW9tg@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement  (Philip Alger <paalger0@gmail.com>)
Responses Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
List pgsql-hackers
Tree view 
On Tue, Oct 14, 2025 at 9:14 PM Philip Alger <paalger0@gmail.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');

pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: refactor func-matching.sgml, make regexp* function more readable
Next
From: Matěj Klonfar
Date:
Subject: Re: [PROPOSAL] comments in repl_scanner