/* Range */

CREATE TABLE range_rel (

id SERIAL PRIMARY KEY,

dt TIMESTAMP NOT NULL);

INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2010-12-31'::date, '1 day') as g;

dt TIMESTAMP NOT NULL,

value INTEGER);

INSERT INTO range_rel (dt, value) SELECT g, extract(day from g) FROM generate_series('2010-01-01'::date, '2010-12-31'::date, '1 day') as g;

SELECT create_range_partitions('range_rel', 'dt', '2010-01-01'::date, '1 month'::interval, 12);

NOTICE: sequence "range_rel_seq" does not exist, skipping

NOTICE: Copying data to partitions...

-> Seq Scan on range_rel_14

(4 rows)

/* Test UPDATE and DELETE */

EXPLAIN (COSTS OFF) UPDATE range_rel SET value = 111 WHERE dt = '2010-06-15';

QUERY PLAN

--------------------------------------------------------------------------------

Update on range_rel_6

-> Seq Scan on range_rel_6

Filter: (dt = 'Tue Jun 15 00:00:00 2010'::timestamp without time zone)

(3 rows)

UPDATE range_rel SET value = 111 WHERE dt = '2010-06-15';

SELECT * FROM range_rel WHERE dt = '2010-06-15';

id | dt | value

-----+--------------------------+-------

166 | Tue Jun 15 00:00:00 2010 | 111

(1 row)

EXPLAIN (COSTS OFF) DELETE FROM range_rel WHERE dt = '2010-06-15';

QUERY PLAN

--------------------------------------------------------------------------------

Delete on range_rel_6

-> Seq Scan on range_rel_6

Filter: (dt = 'Tue Jun 15 00:00:00 2010'::timestamp without time zone)

(3 rows)

DELETE FROM range_rel WHERE dt = '2010-06-15';

SELECT * FROM range_rel WHERE dt = '2010-06-15';

id | dt | value

----+----+-------

(0 rows)

/* Create range partitions from whole range */

SELECT drop_range_partitions('range_rel');

NOTICE: 0 rows copied from range_rel_15

NOTICE: 30 rows copied from range_rel_9

NOTICE: 31 rows copied from range_rel_8

NOTICE: 31 rows copied from range_rel_7

NOTICE:30 rows copied from range_rel_6

NOTICE:29 rows copied from range_rel_6

NOTICE: 31 rows copied from range_rel_5

NOTICE: 30 rows copied from range_rel_4

NOTICE: 31 rows copied from range_rel_3

}

inheritance_disabled= false;

switch(parse->commandType)

{

caseCMD_SELECT:

PartRelationInfo*prel;

List*ranges,

*wrappers=NIL;

RangeTblEntry*rte;

WrapperNode*wrap;

boolfound;

rte= (RangeTblEntry*)linitial(parse->rtable);

prel=get_pathman_relation_info(rte->relid,&found);

if (!found)

return;

ranges=list_make1_int(make_irange(0,prel->children_count-1, false));

wrap=walk_expr_tree( (Expr*)parse->jointree->quals,prel);

wrappers=lappend(wrappers,wrap);

ranges=irange_list_intersect(ranges,wrap->rangeset);

if (irange_list_length(ranges)==1)

{

IndexRangeirange= (IndexRange)linitial_oid(ranges);

elog(WARNING,"lower: %d, upper: %d, lossy: %d",irange_lower(irange),irange_upper(irange),irange_is_lossy(irange));

if (irange_lower(irange)==irange_upper(irange))

{

Oid*children= (Oid*)dsm_array_get_pointer(&prel->children);

CREATETABLErange_rel (

idSERIALPRIMARY KEY,

dtTIMESTAMPNOT NULL);

INSERT INTO range_rel (dt)SELECT gFROM generate_series('2010-01-01'::date,'2010-12-31'::date,'1 day')as g;

dtTIMESTAMPNOT NULL,

valueINTEGER);

INSERT INTO range_rel (dt, value)SELECT g, extract(dayfrom g)FROM generate_series('2010-01-01'::date,'2010-12-31'::date,'1 day')as g;

SELECT create_range_partitions('range_rel','dt','2010-01-01'::date,'1 month'::interval,12);

SELECT merge_range_partitions('range_rel_1','range_rel_2');

SELECT split_range_partition('range_rel_1','2010-02-15'::date);

EXPLAIN (COSTS OFF)SELECT*FROM range_relWHERE dt<'2010-03-01';

EXPLAIN (COSTS OFF)SELECT*FROM range_relWHERE dt>'2010-12-15';

EXPLAIN (COSTS OFF)UPDATE range_relSET value=111WHERE dt='2010-06-15';

UPDATE range_relSET value=111WHERE dt='2010-06-15';

SELECT*FROM range_relWHERE dt='2010-06-15';

EXPLAIN (COSTS OFF)DELETEFROM range_relWHERE dt='2010-06-15';

DELETEFROM range_relWHERE dt='2010-06-15';

SELECT*FROM range_relWHERE dt='2010-06-15';

SELECT drop_range_partitions('range_rel');

SELECT create_partitions_from_range('range_rel','id',1,1000,100);