Quick Links

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

From:	Philip Alger <paalger0(at)gmail(dot)com>
To:	Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc:	Soumya S Murali <soumyamurali(dot)work(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Date:	2026-07-20 16:00:52
Message-ID:	CAPXBC8L_fuv9zPvFaVVT8Scb=mArDUz4riZn9nEydJbOhtc8Xg@mail.gmail.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi Marcos,

> this will make it incompatible with pg_get_table_ddl, because that
> function uses your code and might not return this way since the user could
> be cloning a table to a different schema.
>
>
I am not sure I understand. Could you provide an example, please? Thanks.

--
Best,
Phil Alger
EDB: https://www.enterprisedb.com

In response to

Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement at 2026-07-17 13:41:06 from Marcos Pegoraro

Responses

Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement at 2026-07-20 16:21:38 from Marcos Pegoraro

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Paul A Jungwirth	2026-07-20 16:21:06	Re: Fix RETURNING side effects for FOR PORTION OF leftover rows
Previous Message	Corey Huinker	2026-07-20 15:57:51	Re: The PostgreSQL C Dialect