We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent91a7769 commit2765916Copy full SHA for 2765916
expected/pg_pathman.out
@@ -424,4 +424,16 @@ SELECT pathman.drop_range_partitions('test.num_range_rel');
424
(1 row)
425
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
439
DROP EXTENSION pg_pathman;
sql/hash.sql
@@ -119,14 +119,6 @@ BEGIN
119
EXECUTE format('DROP TABLE %s',rec.inhrelid::regclass::text);
120
END LOOP;
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
/* Notify backend about changes*/
131
PERFORM @extschema@.on_remove_partitions(relation::regclass::oid);
132
END
sql/pg_pathman.sql
@@ -112,4 +112,9 @@ DROP TABLE test.hash_rel CASCADE;
112
SELECTpathman.drop_range_partitions('test.num_range_rel');
113
DROPTABLEtest.num_range_rel CASCADE;
114
115
+SELECTpathman.drop_range_partitions('test.range_rel');
116
+DROPTABLEtest.range_rel CASCADE;
117
118
+SELECT*FROMpathman.pathman_config;
sql/range.sql
@@ -576,6 +576,8 @@ $$
576
DECLARE
577
v_rec RECORD;
578
BEGIN
579
+ relation := @extschema@.validate_relname(relation);
580
581
/* Drop trigger first*/
582
PERFORM @extschema@.drop_range_triggers(relation);
583