Commit4fe43aa

committed

pathman: minor fixes

1 parenta0515ba commit4fe43aaCopy full SHA for 4fe43aa

File tree

+20

-9

lines changed

+20

-9

lines changed

Lines changed: 12 additions & 0 deletions

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;`

Lines changed: 1 addition & 1 deletion

Lines changed: 0 additions & 8 deletions

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`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -112,4 +112,9 @@ DROP TABLE test.hash_rel CASCADE;`
`112`	`112`	`SELECTpathman.drop_range_partitions('test.num_range_rel');`
`113`	`113`	`DROPTABLEtest.num_range_rel CASCADE;`
`114`	`114`
	`115`	`+SELECTpathman.drop_range_partitions('test.range_rel');`
	`116`	`+DROPTABLEtest.range_rel CASCADE;`
	`117`	`+`
	`118`	`+SELECT*FROMpathman.pathman_config;`
	`119`	`+`
`115`	`120`	`DROP EXTENSION pg_pathman;`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -576,6 +576,8 @@ $$`
`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`

Comments

(0)