transforms_and_event_triggers.sql

DROP EVENT TRIGGER IF EXISTS regress_event_trigger_start;
DROP EVENT TRIGGER IF EXISTS regress_event_trigger_end;

-- Clean up extensions from the last run since the last run likely
-- ERROR'ed out.
DROP EXTENSION IF EXISTS hstore_plpython2u;
DROP EXTENSION IF EXISTS plpython2u;
DROP EXTENSION IF EXISTS hstore;

DROP FUNCTION IF EXISTS test_event_trigger() CASCADE;

create function test_event_trigger() returns event_trigger as $$
BEGIN
    RAISE NOTICE 'test_event_trigger: % %', tg_event, tg_tag;
END
$$ language plpgsql;

create event trigger regress_event_trigger_start on ddl_command_start
   execute procedure test_event_trigger();

create event trigger regress_event_trigger_end on ddl_command_end
   execute procedure test_event_trigger();


DROP EXTENSION IF EXISTS hstore_plpython2u;
DROP EXTENSION IF EXISTS plpython2u;
DROP EXTENSION IF EXISTS hstore;

CREATE EXTENSION hstore;
CREATE EXTENSION plpython2u;
CREATE EXTENSION hstore_plpython2u;

-- Here's where I get:
-- ERROR:  requested object address for unsupported object class 32: text result "unrecognized object 3576 109763 0"
DROP EXTENSION hstore_plpython2u;
DROP EXTENSION plpython2u;
DROP EXTENSION hstore;