Re: event triggers in 9.3.4

>> You could compare list of tables before (_start) and after (_end) the ddl. Doing it in plpgsql will be tricky, but if you'd use some other language - like plperl - it's relatively simple:  http://www.depesz.com/2013/12/18/waiting-for-9-4-plperl-add-event-trigger-support/

Thank You Depesz.  This will work for ‘CREATE’ and ‘DROP’ DDLs.

But, what about the scenario where I want to just have event triggers for operations like these? - 'ALTER TABLE','ALTER TRIGGER', 'ALTER FUNCTION'

CREATE EVENT TRIGGER log_ddl_info_start

ON

ddl_command_start

when

tag in

('ALTER TABLE','ALTER TRIGGER','CREATE FUNCTION','ALTER FUNCTION')

EXECUTE PROCEDURE

log_ddl_execution();

In this case, is there a way to capture the object that was altered?

Thank You

Ramya