Index Cond: (dt <= 'Thu Jan 15 00:00:00 2015'::timestamp without time zone)

(4 rows)

CREATE TABLE test.range_rel_test1 (

id SERIAL PRIMARY KEY,

dt TIMESTAMP,

txt TEXT,

abc INTEGER);

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_test1', '2013-01-01'::DATE, '2014-01-01'::DATE);

ERROR: Partition must have the exact same structure as parent P0001

CREATE TABLE test.range_rel_test2 (

id SERIAL PRIMARY KEY,

dt TIMESTAMP);

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_test2', '2013-01-01'::DATE, '2014-01-01'::DATE);

ERROR: Partition must have the exact same structure as parent P0001

/*

* Clean up

*/

$$

LANGUAGE plpgsql;

CREATEOR REPLACE FUNCTION @extschema@.validate_relations_equality(relation1OID, relation2OID)

RETURNSBOOLEANAS

$$

DECLARE

rec RECORD;

FOR recIN (

WITH

a1AS (select*from pg_attributewhere attrelid= relation1and attnum>0),

a2AS (select*from pg_attributewhere attrelid= relation2and attnum>0)

SELECTa1.attname name1,a2.attname name2,a1.atttypid type1,a2.atttypid type2

FROM a1

FULLJOIN a2ONa1.attnum=a2.attnum

)

LOOP

IFrec.name1 ISNULLORrec.name2 ISNULLORrec.name1!=rec.name2 THEN

RETURN False;

END IF;

END LOOP;

RETURN True;

END

$$

LANGUAGE plpgsql;

RAISE EXCEPTION'Specified range overlaps with existing partitions';

END IF;

IF NOT @extschema@.validate_relations_equality(p_relation::regclass, p_partition::regclass) THEN

RAISE EXCEPTION'Partition must have the exact same structure as parent';

END IF;

EXECUTE format('ALTER TABLE %s INHERIT %s'

, p_partition

EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE dt BETWEEN'2014-11-15'AND'2015-01-15';

SELECTpathman.detach_range_partition('test.range_rel_archive');

EXPLAIN (COSTS OFF)SELECT*FROMtest.range_relWHERE dt BETWEEN'2014-11-15'AND'2015-01-15';

CREATETABLEtest.range_rel_test1 (

idSERIALPRIMARY KEY,

dtTIMESTAMP,

txtTEXT,

abcINTEGER);

SELECTpathman.attach_range_partition('test.range_rel','test.range_rel_test1','2013-01-01'::DATE,'2014-01-01'::DATE);

CREATETABLEtest.range_rel_test2 (

idSERIALPRIMARY KEY,

dtTIMESTAMP);

SELECTpathman.attach_range_partition('test.range_rel','test.range_rel_test2','2013-01-01'::DATE,'2014-01-01'::DATE);