Request a Demo
Home   >   mailing lists

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

From Marcos Pegoraro
Subject Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Date
Msg-id CAB-JLwb=7chi75J9Nfsi+aiHTbUTa7b02m1mezMZMM=AoMaytg@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement  (Jim Jones <jim.jones@uni-muenster.de>)
Responses Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
List pgsql-hackers
Tree view
Em sáb., 18 de out. de 2025 às 12:19, Jim Jones <jim.jones@uni-muenster.de> escreveu:
Other than that, the patch LGTM. If the other reviewers have no
objections, I'll mark it as ready for committer.

Before committing, thinking of all these features, triggers, constraints, tables, etc, to be all of them really useful, wouldn't it be better to have an option to drop them first or create if not exists when available ?

pg_get_trigger_ddl(oid, pretty, drop_first) ?

regards
Marcos

pgsql-hackers by date:

Previous
From: Arseniy Mukhin
Date:
Subject: Re: Optimize LISTEN/NOTIFY
Next
From: Shinya Kato
Date:
Subject: Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls