Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit2765916

Browse files
committed
minor fixes
1 parent91a7769 commit2765916

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
SELECTpathman.drop_range_partitions('test.num_range_rel');
113113
DROPTABLEtest.num_range_rel CASCADE;
114114

115+
SELECTpathman.drop_range_partitions('test.range_rel');
116+
DROPTABLEtest.range_rel CASCADE;
117+
118+
SELECT*FROMpathman.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)

[8]ページ先頭

©2009-2025 Movatter.jp