Commitd7665c3

committed

enable/disable auto partition creation

1 parent3007f79 commitd7665c3Copy full SHA for d7665c3

File tree

+34

-6

lines changed

+34

-6

lines changed

Lines changed: 16 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1256,8 +1256,23 @@ SELECT * FROM test.range_rel WHERE dt = '2015-03-15';`
`1256`	`1256`	`74 \| Sun Mar 15 00:00:00 2015`
`1257`	`1257`	`(1 row)`
`1258`	`1258`
	`1259`	`+SELECT pathman.disable_auto('test.range_rel');`
	`1260`	`+ disable_auto`
	`1261`	`+--------------`
	`1262`	`+`
	`1263`	`+(1 row)`
	`1264`	`+`
	`1265`	`+INSERT INTO test.range_rel (dt) VALUES ('2015-06-01');`
	`1266`	`+ERROR: There is no suitable partition for key 'Mon Jun 01 00:00:00 2015'`
	`1267`	`+SELECT pathman.enable_auto('test.range_rel');`
	`1268`	`+ enable_auto`
	`1269`	`+-------------`
	`1270`	`+`
	`1271`	`+(1 row)`
	`1272`	`+`
	`1273`	`+INSERT INTO test.range_rel (dt) VALUES ('2015-06-01');`
`1259`	`1274`	`DROP TABLE test.range_rel CASCADE;`
`1260`		`-NOTICE: drop cascades to16 other objects`
	`1275`	`+NOTICE: drop cascades to20 other objects`
`1261`	`1276`	`SELECT partrel, attname, parttype, range_interval FROM pathman.pathman_config;`
`1262`	`1277`	`partrel \| attname \| parttype \| range_interval`
`1263`	`1278`	`---------+---------+----------+----------------`

Lines changed: 5 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -525,6 +525,11 @@ SELECT * FROM test.range_rel WHERE dt = '2014-12-15';`
`525`	`525`	`EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE dt='2015-03-15';`
`526`	`526`	`SELECT*FROMtest.range_relWHERE dt='2015-03-15';`
`527`	`527`
	`528`	`+SELECTpathman.disable_auto('test.range_rel');`
	`529`	`+INSERT INTOtest.range_rel (dt)VALUES ('2015-06-01');`
	`530`	`+SELECTpathman.enable_auto('test.range_rel');`
	`531`	`+INSERT INTOtest.range_rel (dt)VALUES ('2015-06-01');`
	`532`	`+`
`528`	`533`	`DROPTABLEtest.range_rel CASCADE;`
`529`	`534`	`SELECT partrel, attname, parttype, range_intervalFROMpathman.pathman_config;`
`530`	`535`

Lines changed: 13 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -204,12 +204,20 @@ partition_filter_exec(CustomScanState *node)`
`204`	`204`	`elog(ERROR,"PartitionFilter selected more than one partition");`
`205`	`205`	`elseif (nparts==0)`
`206`	`206`	`{`
`207`		`-selected_partid=create_partitions(state->partitioned_table,`
`208`		`-state->temp_const.constvalue,`
`209`		`-state->temp_const.consttype);`
	`207`	`+if (prel->auto_partition)`
	`208`	`+{`
	`209`	`+selected_partid=create_partitions(state->partitioned_table,`
	`210`	`+state->temp_const.constvalue,`
	`211`	`+state->temp_const.consttype);`
`210`	`212`
`211`		`-/* get_pathman_relation_info() will refresh this entry */`
`212`		`-invalidate_pathman_relation_info(state->partitioned_table,NULL);`
	`213`	`+/* get_pathman_relation_info() will refresh this entry */`
	`214`	`+invalidate_pathman_relation_info(state->partitioned_table,NULL);`
	`215`	`+}`
	`216`	`+else`
	`217`	`+elog(ERROR,`
	`218`	`+"There is no suitable partition for key '%s'",`
	`219`	`+datum_to_cstring(state->temp_const.constvalue,`
	`220`	`+state->temp_const.consttype));`
`213`	`221`	`}`
`214`	`222`	`else`
`215`	`223`	`selected_partid=parts[0];`

Comments

(0)