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

From: Philip Alger <paalger0(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Date: 2025-10-16 12:38:55
Message-ID: CAPXBC8J9qxDA827+z2x55N8=Qpd6_PQqqLC0qdVsPNRrHVPBbw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Jian,

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

Yes, I had the same idea last night. Running PG_RETURN_NULL would also be
similar to how other functions handle it.

Thanks, and I will make the change.

--
Best, Phil Alger

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Akshay Joshi 2025-10-16 12:50:50 Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement
Previous Message Philip Alger 2025-10-16 12:36:05 Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement