v_recRECORD;

v_rowsBIGINT;

v_part_countINTEGER :=0;

conf_num_delINTEGER;

conf_numINTEGER;

v_relkindCHAR;

PERFORM @extschema@.validate_relname(parent_relid);

PERFORM @extschema@.drop_triggers(parent_relid);

PERFORM @extschema@.prevent_relation_modification(parent_relid);

WITH config_num_deletedAS (DELETEFROM @extschema@.pathman_config

WHERE partrel= parent_relid

RETURNING*)

SELECTcount(*)from config_num_deleted INTO conf_num_del;

PERFORM @extschema@.drop_triggers(parent_relid);

DELETEFROM @extschema@.pathman_config_paramsWHERE partrel= parent_relid;

SELECTcount(*)FROM @extschema@.pathman_config

WHERE partrel= parent_relid INTO conf_num;

IFconf_num_del=0 THEN

IFconf_num=0 THEN

RAISE EXCEPTION'relation "%" has no partitions', parent_relid::TEXT;

END IF;

INTO v_relkind;

IF v_relkind='f' THEN

v_part_count := v_part_count+1;

END LOOP;

DELETEFROM @extschema@.pathman_configWHERE partrel= parent_relid;

DELETEFROM @extschema@.pathman_config_paramsWHERE partrel= parent_relid;

RETURN v_part_count;

END

$$ LANGUAGE plpgsql