-> Seq Scan on range_rel_14

(4 rows)

/* Temporary table for JOINs */

CREATE TABLE tmp (id INTEGER NOT NULL, value INTEGER NOT NULL);

INSERT INTO tmp VALUES (1, 1), (2, 2);

/* Test UPDATE and DELETE */

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

QUERY PLAN

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

(0 rows)

EXPLAIN (COSTS OFF) UPDATE range_rel r SET value = t.value FROM tmp t WHERE r.dt = '2010-01-01' AND r.id = t.id;

QUERY PLAN

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

Update on range_rel_1 r

-> Hash Join

Hash Cond: (t.id = r.id)

-> Seq Scan on tmp t

-> Hash

-> Index Scan using range_rel_1_pkey on range_rel_1 r

Filter: (dt = 'Fri Jan 01 00:00:00 2010'::timestamp without time zone)

(7 rows)

UPDATE range_rel r SET value = t.value FROM tmp t WHERE r.dt = '2010-01-01' AND r.id = t.id;

EXPLAIN (COSTS OFF) DELETE FROM range_rel r USING tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;

QUERY PLAN

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

Delete on range_rel_1 r

-> Hash Join

Hash Cond: (t.id = r.id)

-> Seq Scan on tmp t

-> Hash

-> Index Scan using range_rel_1_pkey on range_rel_1 r

Filter: (dt = 'Sat Jan 02 00:00:00 2010'::timestamp without time zone)

(7 rows)

DELETE FROM range_rel r USING tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;

/* Create range partitions from whole range */

SELECT drop_range_partitions('range_rel');

NOTICE: 0 rows copied from range_rel_15

NOTICE: 31 rows copied from range_rel_5

NOTICE: 30 rows copied from range_rel_4

NOTICE: 31 rows copied from range_rel_3

NOTICE:45 rows copied from range_rel_1

NOTICE:44 rows copied from range_rel_1

drop_range_partitions

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

14

WrapperNode*wrap;

boolfound;

if (list_length(parse->rtable)!=1)

return;

Assert(parse->commandType==CMD_UPDATE||

parse->commandType==CMD_DELETE);

Assert(parse->resultRelation>0);

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

rte=rt_fetch(parse->resultRelation,parse->rtable);

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

if (!found)

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

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

CREATETABLEtmp (idINTEGERNOT NULL, valueINTEGERNOT NULL);

INSERT INTO tmpVALUES (1,1), (2,2);

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

EXPLAIN (COSTS OFF)UPDATE range_rel rSET value=t.valueFROM tmp tWHEREr.dt='2010-01-01'ANDr.id=t.id;

UPDATE range_rel rSET value=t.valueFROM tmp tWHEREr.dt='2010-01-01'ANDr.id=t.id;

EXPLAIN (COSTS OFF)DELETEFROM range_rel r USING tmp tWHEREr.dt='2010-01-02'ANDr.id=t.id;

DELETEFROM range_rel r USING tmp tWHEREr.dt='2010-01-02'ANDr.id=t.id;

SELECT drop_range_partitions('range_rel');