DROP TABLE test.hash_rel CASCADE;

SELECT pathman.drop_range_partitions('test.num_range_rel');

NOTICE: 0 rows copied from test.num_range_rel_7

NOTICE: 0 rows copied from test.num_range_rel_6

NOTICE: 2 rows copied from test.num_range_rel_4

NOTICE: 1000 rows copied from test.num_range_rel_3

NOTICE: 1000 rows copied from test.num_range_rel_2

NOTICE: 998 rows copied from test.num_range_rel_1

drop_range_partitions

-----------------------

(1 row)

DROP TABLE test.num_range_rel CASCADE;

/* Create range partitions from whole range */

SELECT drop_range_partitions('range_rel');

NOTICE: 0 rows copied from range_rel_archive

NOTICE: 0 rows copied from range_rel_15

NOTICE: 0 rows copied from range_rel_14

NOTICE: 14 rows copied from range_rel_13

NOTICE: 31 rows copied from range_rel_12

NOTICE: 30 rows copied from range_rel_11

NOTICE: 31 rows copied from range_rel_10

NOTICE: 30 rows copied from range_rel_9

NOTICE: 31 rows copied from range_rel_8

NOTICE: 31 rows copied from range_rel_7

NOTICE: 30 rows copied from range_rel_6

NOTICE: 31 rows copied from range_rel_5

NOTICE: 30 rows copied from range_rel_4

NOTICE: 31 rows copied from range_rel_3

NOTICE: 45 rows copied from range_rel_1

drop_range_partitions

-----------------------

(1 row)

SELECT create_partitions_from_range('range_rel', 'id', 1, 1000, 100);

(1 row)

SELECT drop_range_partitions('range_rel');

NOTICE: 0 rows copied from range_rel_10

NOTICE: 0 rows copied from range_rel_9

NOTICE: 0 rows copied from range_rel_8

NOTICE: 0 rows copied from range_rel_7

NOTICE: 0 rows copied from range_rel_6

NOTICE: 0 rows copied from range_rel_5

NOTICE: 65 rows copied from range_rel_4

NOTICE: 100 rows copied from range_rel_3

NOTICE: 100 rows copied from range_rel_2

NOTICE: 100 rows copied from range_rel_1

drop_range_partitions

-----------------------

(1 row)

SELECT create_partitions_from_range('range_rel', 'dt', '2015-01-01'::date, '2015-12-01'::date, '1 month'::interval);

CREATEOR REPLACE FUNCTION @extschema@.drop_range_partitions(IN relationTEXT)

RETURNSVOIDAS

RETURNSINTEGERAS

$$

DECLARE

v_rec RECORD;

v_rowsINTEGER;

v_part_countINTEGER :=0;

relation := @extschema@.validate_relname(relation);

PERFORM @extschema@.drop_range_triggers(relation);

FOR v_recIN (SELECT inhrelid::regclassAS tbl

FOR v_recIN (SELECT inhrelid::regclass::textAS tbl

FROM pg_inheritsWHERE inhparent= relation::regclass::oid)

LOOP

EXECUTE format('WITH part_data AS (DELETE FROM %s RETURNING *)

,v_rec.tbl

, relation);

GET DIAGNOSTICS v_rows= ROW_COUNT;

EXECUTE format('DROP TABLE %s',v_rec.tbl);

RAISE NOTICE'% rows copied from %', v_rows,v_rec.tbl;

v_part_count := v_part_count+1;

END LOOP;

DELETEFROM @extschema@.pathman_configWHERE relname= relation;

PERFORM @extschema@.on_remove_partitions(relation::regclass::oid);

RETURN v_part_count;

END

$$ LANGUAGE plpgsql;