DROP SCHEMA calamity CASCADE;

NOTICE: drop cascades to 18 other objects

DROP EXTENSION pg_pathman;

/*

* ------------------------------------------

* Special tests (uninitialized pg_pathman)

* ------------------------------------------

*/

CREATE SCHEMA calamity;

CREATE EXTENSION pg_pathman;

/* check function pathman_cache_search_relid() */

CREATE TABLE calamity.survivor(val INT NOT NULL);

SELECT create_range_partitions('calamity.survivor', 'val', 1, 10, 2);

NOTICE: sequence "survivor_seq" does not exist, skipping

create_range_partitions

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

2

(1 row)

DROP EXTENSION pg_pathman CASCADE;

SET pg_pathman.enable = f; /* DON'T LOAD CONFIG */

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

CREATE EXTENSION pg_pathman;

SHOW pg_pathman.enable;

pg_pathman.enable

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

off

(1 row)

SELECT add_to_pathman_config('calamity.survivor', 'val', '10');/* not ok */

ERROR: pg_pathman is not initialized yet

SELECT * FROM pathman_partition_list;/* not ok */

ERROR: pg_pathman is not initialized yet

SELECT get_part_range('calamity.survivor', 0, NULL::INT);/* not ok */

ERROR: pg_pathman is not initialized yet

EXPLAIN (COSTS OFF) SELECT * FROM calamity.survivor;/* OK */

QUERY PLAN

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

Append

-> Seq Scan on survivor

-> Seq Scan on survivor_1

-> Seq Scan on survivor_2

(4 rows)

SET pg_pathman.enable = t; /* LOAD CONFIG */

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

SELECT add_to_pathman_config('calamity.survivor', 'val', '10');/* OK */

add_to_pathman_config

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

t

(1 row)

SELECT * FROM pathman_partition_list;/* OK */

parent | partition | parttype | partattr | range_min | range_max

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

calamity.survivor | calamity.survivor_1 | 2 | val | 1 | 11

calamity.survivor | calamity.survivor_2 | 2 | val | 11 | 21

(2 rows)

SELECT get_part_range('calamity.survivor', 0, NULL::INT);/* OK */

get_part_range

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

{1,11}

(1 row)

EXPLAIN (COSTS OFF) SELECT * FROM calamity.survivor;/* OK */

QUERY PLAN

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

Append

-> Seq Scan on survivor_1

-> Seq Scan on survivor_2

(3 rows)

DROP TABLE calamity.survivor CASCADE;

NOTICE: drop cascades to 2 other objects

DROP SCHEMA calamity CASCADE;

NOTICE: drop cascades to sequence calamity.survivor_seq

DROP EXTENSION pg_pathman;

DROPTABLEcalamity.test_range_oid CASCADE;

DROPSCHEMA calamity CASCADE;

DROP EXTENSION pg_pathman;

CREATESCHEMAcalamity;

CREATE EXTENSION pg_pathman;

CREATETABLEcalamity.survivor(valINTNOT NULL);

SELECT create_range_partitions('calamity.survivor','val',1,10,2);

DROP EXTENSION pg_pathman CASCADE;

SETpg_pathman.enable= f;/* DON'T LOAD CONFIG*/

CREATE EXTENSION pg_pathman;

SHOWpg_pathman.enable;

SELECT add_to_pathman_config('calamity.survivor','val','10');/* not ok*/

SELECT*FROM pathman_partition_list;/* not ok*/

SELECT get_part_range('calamity.survivor',0,NULL::INT);/* not ok*/

EXPLAIN (COSTS OFF)SELECT*FROMcalamity.survivor;/* OK*/

SETpg_pathman.enable= t;/* LOAD CONFIG*/

SELECT add_to_pathman_config('calamity.survivor','val','10');/* OK*/

SELECT*FROM pathman_partition_list;/* OK*/

SELECT get_part_range('calamity.survivor',0,NULL::INT);/* OK*/

EXPLAIN (COSTS OFF)SELECT*FROMcalamity.survivor;/* OK*/

DROPTABLEcalamity.survivor CASCADE;

DROPSCHEMA calamity CASCADE;

DROP EXTENSION pg_pathman;

{

switch (action)

{

caseHASH_FIND:

caseHASH_REMOVE:

if (!cache_table)

returnNULL;

break;

caseHASH_ENTER:

if (!cache_table)

elog(ERROR,"pg_pathman is not initialized yet");

break;

}

Assert(cache_table);

AssertArg(cache_table);

returnhash_search(cache_table, (constvoid*)&relid,action,found);