@@ -89,6 +89,7 @@ DROP FUNCTION @extschema@.on_create_partitions(REGCLASS);
8989DROP FUNCTION @extschema@.on_update_partitions(REGCLASS);
9090DROP FUNCTION @extschema@.on_remove_partitions(REGCLASS);
9191DROP FUNCTION @extschema@.is_attribute_nullable(REGCLASS,TEXT );
92+ DROP FUNCTION @extschema@.build_check_constraint_name(REGCLASS,TEXT );
9293DROP FUNCTION @extschema@.build_check_constraint_name(REGCLASS, INT2);
9394DROP FUNCTION @extschema@.add_to_pathman_config(REGCLASS,TEXT ,TEXT );
9495DROP FUNCTION @extschema@.lock_partitioned_relation(REGCLASS);
257258$$ LANGUAGE plpgsql;
258259
259260
261+ CREATEOR REPLACE FUNCTION @extschema@.pathman_ddl_trigger_func()
262+ RETURNS event_triggerAS $$
263+ DECLARE
264+ objRECORD;
265+ pg_class_oidOID ;
266+ relidsREGCLASS[];
267+
268+ BEGIN
269+ pg_class_oid= ' pg_catalog.pg_class'
270+
271+ /* Find relids to remove from config*/
272+ SELECT array_agg(cfg .partrel ) INTO relids
273+ FROM pg_event_trigger_dropped_objects()AS events
274+ JOIN @extschema@.pathman_configAS cfgON cfg .partrel ::oid = events .objid
275+ WHERE events .classid = pg_class_oidAND events .objsubid = 0 ;
276+
277+ /* Cleanup pathman_config*/
278+ DELETE FROM @extschema@.pathman_configWHERE partrel= ANY(relids);
279+
280+ /* Cleanup params table too*/
281+ DELETE FROM @extschema@.pathman_config_paramsWHERE partrel= ANY(relids);
282+ END
283+ $$ LANGUAGE plpgsql;
284+
285+
260286CREATEOR REPLACE FUNCTION @extschema@.create_naming_sequence(
261287parent_relidREGCLASS)
262288RETURNSTEXT AS $$