DROP TABLE test.provided_part_names CASCADE;

NOTICE: drop cascades to 2 other objects

/* test preventing of double expand of inherited tables */

CREATE TABLE test.mixinh_parent (id INT PRIMARY KEY);

CREATE TABLE test.mixinh_child1 () INHERITS (test.mixinh_parent);

SELECT create_range_partitions('test.mixinh_child1', 'id', 1, 10, 1);

create_range_partitions

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

1

(1 row)

INSERT INTO test.mixinh_child1 VALUES (1);

SELECT * FROM test.mixinh_child1;

id

----

1

(1 row)

SELECT * FROM test.mixinh_parent;

ERROR: could not expand partitioned table "mixinh_child1"

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to28 other objects

NOTICE: drop cascades to32 other objects

DROP EXTENSION pg_pathman CASCADE;

DROP SCHEMA pathman CASCADE;

DROPTABLEtest.provided_part_names CASCADE;

CREATETABLEtest.mixinh_parent (idINTPRIMARY KEY);

CREATETABLEtest.mixinh_child1 () INHERITS (test.mixinh_parent);

SELECT create_range_partitions('test.mixinh_child1','id',1,10,1);

INSERT INTOtest.mixinh_child1VALUES (1);

SELECT*FROMtest.mixinh_child1;

SELECT*FROMtest.mixinh_parent;

DROPSCHEMA test CASCADE;

DROP EXTENSION pg_pathman CASCADE;

DROPSCHEMA pathman CASCADE;

if (appinfo->child_relid==rti&&

OidIsValid(appinfo->parent_reloid))

{

gotocleanup;

if (child_oid==parent_oid)

gotocleanup;

elseif (!has_pathman_relation_info(parent_oid))

ereport(ERROR,

(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),

errmsg("could not expand partitioned table \"%s\"",

get_rel_name(child_oid)),

errhint("Do not use inheritance and pg_pathman partitions together")));

}

}

}