DROP EXTENSION pg_pathman;

-- create it for further tests

CREATE EXTENSION pg_pathman;

-- make sure nothing breaks on disable/enable

SET pg_pathman.enable = false;

NOTICE: RuntimeAppend, RuntimeMergeAppend and PartitionFilter nodes and some other options have been disabled

SET pg_pathman.enable = true;

NOTICE: RuntimeAppend, RuntimeMergeAppend and PartitionFilter nodes and some other options have been enabled

-- 079797e0d5

CREATE TABLE part_test(val serial);

INSERT INTO part_test SELECT generate_series(1, 30);

CREATE EXTENSION pg_pathman;

SETpg_pathman.enable= false;

SETpg_pathman.enable= true;

CREATETABLEpart_test(valserial);

INSERT INTO part_testSELECT generate_series(1,30);

}

MemoryContextReset(PathmanParentsCacheContext);

MemoryContextReset(PathmanStatusCacheContext);

MemoryContextReset(PathmanBoundsCacheContext);

if (TopPathmanContext)

{

MemoryContextReset(PathmanParentsCacheContext);

MemoryContextReset(PathmanStatusCacheContext);

MemoryContextReset(PathmanBoundsCacheContext);

}

}