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

[Philip Alger]

On Mon, Oct 13, 2025 at 9:28 PM jian he <jian.universal...@gmail.com> wrote:

>
> I just did a quick test.
>
> src1=# SELECT pg_get_trigger_ddl(2, 'foo_trigger');
> ERROR:  trigger "foo_trigger" for table "(null)" does not exist
> src1=# SELECT pg_get_trigger_ddl(0, 'foo_trigger');
> ERROR:  trigger "foo_trigger" for table "(null)" does not exist
>
> this error message is use facing, is the above error message what we
> expected?
>

Thank you for checking that. Short answer: no.

Please see v2. The latest version should take care of the (null) relation
issue now, since it is checking if the OID exists for the table. I've
included a test for that as well. It should return a clearer error if the
relation does not exist.

-- 
Best,
Phil Alger

v2-0001-Add-pg_get_trigger_ddl-function.patch
Description: Binary data