Request a Demo
Home   >   mailing lists

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

From Philip Alger
Subject Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Date
Msg-id CAPXBC8+bVv6ykajwSMMmS8pm_=fy=eRx-g91A9zhsBPpoHf0Jw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
List pgsql-hackers
Tree view
Hi Marcos,


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) 

I’m not sure what you’re saying here. There is no pretty  option for this one, and the intent is for the user to be able to input a table and trigger to get the CREATE TRIGGER statement. Not sure how drop_first fits in here; we’re not dropping or creating triggers. 

Best, 
Phil Alger


pgsql-hackers by date:

Previous
From: Shinya Kato
Date:
Subject: Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls
Next
From: Bryan Green
Date:
Subject: [PATCH] Fix POSIX compliance in pgwin32_unsetenv()