\set VERBOSITY terse

-- is pathman (caches, in particular) strong enough to carry out this?

SET search_path = 'public';

-- make sure nothing breaks on disable/enable when nothing was initialized yet

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

-- wobble with create-drop ext: tests cached relids sanity

CREATE EXTENSION pg_pathman;

SET pg_pathman.enable = f;

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

SET search_path='public';

SETpg_pathman.enable= false;

SETpg_pathman.enable= true;

CREATE EXTENSION pg_pathman;

SETpg_pathman.enable= f;

CREATE EXTENSION pg_pathman;

SETpg_pathman.enable= false;

SETpg_pathman.enable= true;

CREATETABLEpart_test(valserial);

INSERT INTO part_testSELECT generate_series(1,30);