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

Поиск
Список
Период
Сортировка
От Philip Alger
Тема Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Дата
Msg-id CAPXBC8+bVv6ykajwSMMmS8pm_=fy=eRx-g91A9zhsBPpoHf0Jw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement  (Marcos Pegoraro <marcos@f10.com.br>)
Ответы Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement
Список pgsql-hackers
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 по дате отправления: