DATA_built = pg_pathman--$(EXTVERSION).sql

DATA = pg_pathman--1.0--1.1.sql\

pg_pathman--1.1--1.2.sql

pg_pathman--1.1--1.2.sql\

pg_pathman--1.2--1.3.sql

PGFILEDESC = "pg_pathman - partitioning tool"

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;

CREATEOR REPLACE FUNCTION @extschema@.show_partition_list()

RETURNS TABLE (

parentREGCLASS,

"partition"REGCLASS,

partitionREGCLASS,

parttypeINT4,

partattrTEXT,

range_minTEXT,

CREATEOR REPLACE FUNCTION @extschema@.invoke_on_partition_created_callback(

parent_relidREGCLASS,

"partition"REGCLASS,

partition_relidREGCLASS,

init_callbackREGPROCEDURE,

start_valueANYELEMENT,

end_valueANYELEMENT)

CREATEOR REPLACE FUNCTION @extschema@.invoke_on_partition_created_callback(

parent_relidREGCLASS,

"partition"REGCLASS,

partition_relidREGCLASS,

init_callbackREGPROCEDURE)

RETURNS VOIDAS'pg_pathman','invoke_on_partition_created_callback'

LANGUAGE C;