Skip to content

Commit 2765916

Browse files
committed
minor fixes
1 parent 91a7769 commit 2765916

File tree

4 files changed

+19
-8
lines changed

4 files changed

+19
-8
lines changed

expected/pg_pathman.out

Lines changed: 12 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -424,4 +424,16 @@ SELECT pathman.drop_range_partitions('test.num_range_rel');
424424
(1 row)
425425

426426
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+
427439
DROP EXTENSION pg_pathman;

sql/hash.sql

Lines changed: 0 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -119,14 +119,6 @@ BEGIN
119119
EXECUTE format('DROP TABLE %s', rec.inhrelid::regclass::text);
120120
END LOOP;
121121

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-
130122
/* Notify backend about changes */
131123
PERFORM @extschema@.on_remove_partitions(relation::regclass::oid);
132124
END

sql/pg_pathman.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -112,4 +112,9 @@ DROP TABLE test.hash_rel CASCADE;
112112
SELECT pathman.drop_range_partitions('test.num_range_rel');
113113
DROP TABLE test.num_range_rel CASCADE;
114114

115+
SELECT pathman.drop_range_partitions('test.range_rel');
116+
DROP TABLE test.range_rel CASCADE;
117+
118+
SELECT * FROM pathman.pathman_config;
119+
115120
DROP EXTENSION pg_pathman;

sql/range.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -576,6 +576,8 @@ $$
576576
DECLARE
577577
v_rec RECORD;
578578
BEGIN
579+
relation := @extschema@.validate_relname(relation);
580+
579581
/* Drop trigger first */
580582
PERFORM @extschema@.drop_range_triggers(relation);
581583

0 commit comments

Comments
 (0)