zof [20410]=# CREATE OR REPLACE FUNCTION ddl_log_sql_drop()
zof-# RETURNS event_trigger
zof-# LANGUAGE plpgsql
zof-# SECURITY DEFINER
zof-# AS $function$
zof$# DECLARE
zof$# obj record;
zof$# BEGIN
zof$# FOR obj IN
zof$# SELECT *
zof$# FROM pg_catalog.pg_event_trigger_dropped_objects()
zof$# LOOP
zof$# RAISE NOTICE 'DROP objet : % % % %',
zof$# obj.object_type,
zof$# obj.schema_name,
zof$# obj.object_name,
zof$# obj.object_identity;
zof$# END LOOP;
zof$# END;
zof$# $function$;
CREATE EVENT TRIGGER ddl_log_sql_drop ON sql_drop
NOTICE: CREATE FUNCTION objet : function zof.zof.ddl_log_sql_drop()
EXECUTE PROCEDURE ddl_log_sql_drop(); CREATE FUNCTION
zof [20410]=# CREATE EVENT TRIGGER ddl_log_sql_drop ON sql_drop
zof-# EXECUTE PROCEDURE ddl_log_sql_drop();
CREATE EVENT TRIGGER
zof [20410]=# drop table za;
NOTICE: DROP objet : table zof za zof.za
NOTICE: DROP objet : type zof za zof.za
NOTICE: DROP objet : type zof _za zof.za[]
DROP TABLE