Re: [GENERAL] Event Trigger question

Oh duh, I'm blind... Thanks! On 07/13/2017 07:29 PM, David G. Johnston wrote: On Thursday, July 13, 2017, ProPAAS DBA > wrote: 2) where can I find a complete list of the tg_ variables? I see this list: https://www.postgresql.org/docs/9.4/static/plpgsql-tri

Re: [GENERAL] Event Trigger question

On Thursday, July 13, 2017, ProPAAS DBA wrote: > > 2) where can I find a complete list of the tg_ variables? I see this > list:https://www.postgresql.org/docs/9.4/static/plpgsql-trigger.html > > which includes TG_NAME. OLD, NEW, etc but tg_tag and tg_event are not in the > list. Are there other

[GENERAL] Event Trigger question

Hi All; we are creating an event trigger on ddl_command_end and I want the function to know the TABLE and COMMAND run, for example if the ddl command was an "ALTER TABLE ADD COLUMN X" then I want to pull the table and the actual alter command. We're running version 9.4 so the pg_event_trigge