File tree Expand file tree Collapse file tree 4 files changed +19
-8
lines changed Expand file tree Collapse file tree 4 files changed +19
-8
lines changed Original file line number Diff line number Diff line change @@ -424,4 +424,16 @@ SELECT pathman.drop_range_partitions('test.num_range_rel');
424
424
(1 row)
425
425
426
426
DROP TABLE test.num_range_rel CASCADE;
427
+ SELECT pathman.drop_range_partitions('test.range_rel');
428
+ drop_range_partitions
429
+ -----------------------
430
+
431
+ (1 row)
432
+
433
+ DROP TABLE test.range_rel CASCADE;
434
+ SELECT * FROM pathman.pathman_config;
435
+ id | relname | attname | parttype
436
+ ----+---------+---------+----------
437
+ (0 rows)
438
+
427
439
DROP EXTENSION pg_pathman;
Original file line number Diff line number Diff line change @@ -119,14 +119,6 @@ BEGIN
119
119
EXECUTE format(' DROP TABLE %s' , rec .inhrelid ::regclass::text );
120
120
END LOOP;
121
121
122
- -- FOR rec in (SELECT * FROM pg_inherits WHERE inhparent = relation::regclass::oid)
123
- -- LOOP
124
- -- EXECUTE format('DROP FUNCTION IF EXISTS %s_hash_update_trigger_func() CASCADE'
125
- -- , @extschema@.get_schema_qualified_name(relation::regclass)
126
- -- , num);
127
- -- num := num + 1;
128
- -- END LOOP;
129
-
130
122
/* Notify backend about changes */
131
123
PERFORM @extschema@.on_remove_partitions(relation::regclass::oid );
132
124
END
Original file line number Diff line number Diff line change @@ -112,4 +112,9 @@ DROP TABLE test.hash_rel CASCADE;
112
112
SELECT pathman .drop_range_partitions (' test.num_range_rel' );
113
113
DROP TABLE test .num_range_rel CASCADE;
114
114
115
+ SELECT pathman .drop_range_partitions (' test.range_rel' );
116
+ DROP TABLE test .range_rel CASCADE;
117
+
118
+ SELECT * FROM pathman .pathman_config ;
119
+
115
120
DROP EXTENSION pg_pathman;
Original file line number Diff line number Diff line change 576
576
DECLARE
577
577
v_rec RECORD;
578
578
BEGIN
579
+ relation := @extschema@.validate_relname(relation);
580
+
579
581
/* Drop trigger first */
580
582
PERFORM @extschema@.drop_range_triggers(relation);
581
583
You can’t perform that action at this time.
0 commit comments