(5 rows)

DROP TABLE test.improved_dummy CASCADE;

NOTICE: drop cascades to11 other objects

NOTICE: drop cascades to12 other objects

/* since rel_1_4_beta: check create_range_partitions(bounds array) */

CREATE TABLE test.improved_dummy (val INT NOT NULL);

SELECT pathman.create_range_partitions('test.improved_dummy', 'val',

(2 rows)

DROP TABLE test.improved_dummy CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* Test pathman_rel_pathlist_hook() with INSERT query */

CREATE TABLE test.insert_into_select(val int NOT NULL);

INSERT INTO test.insert_into_select SELECT generate_series(1, 100);

(1 row)

DROP TABLE test.insert_into_select_copy, test.insert_into_select CASCADE;

NOTICE: drop cascades to5 other objects

NOTICE: drop cascades to6 other objects

/* Test INSERT hooking with DATE type */

CREATE TABLE test.insert_date_test(val DATE NOT NULL);

SELECT pathman.create_partitions_from_range('test.insert_date_test', 'val',

(1 row)

DROP TABLE test.insert_date_test CASCADE;

NOTICE: drop cascades to8 other objects

NOTICE: drop cascades to9 other objects

SET pg_pathman.enable_runtimeappend = OFF;

SET pg_pathman.enable_runtimemergeappend = OFF;

VACUUM;

(1 row)

DROP TABLE test.zero CASCADE;

NOTICE: drop cascades to4 other objects

NOTICE: drop cascades to5 other objects

/*

* Check that altering table columns doesn't break trigger

*/

DROP TABLE test.num_range_rel CASCADE;

DROP TABLE test.range_rel CASCADE;

NOTICE: drop cascades to9 other objects

NOTICE: drop cascades to10 other objects

/* Test automatic partition creation */

CREATE TABLE test.range_rel (

idSERIAL PRIMARY KEY,

(1 row)

DROP TABLE test.range_rel CASCADE;

NOTICE: drop cascades to20 other objects

NOTICE: drop cascades to21 other objects

SELECT * FROM pathman.pathman_config;

partrel | expr | parttype | range_interval | cooked_expr

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

(1 row)

DROP TABLE test."RangeRel" CASCADE;

NOTICE: drop cascades to5 other objects

NOTICE: drop cascades to6 other objects

SELECT * FROM pathman.pathman_config;

partrel | expr | parttype | range_interval | cooked_expr

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

(1 row)

DROP TABLE test."RangeRel" CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

DROP EXTENSION pg_pathman;

/* Test that everything works fine without schemas */

CREATE EXTENSION pg_pathman;

DROP TABLE test.provided_part_names CASCADE;

NOTICE: drop cascades to 2 other objects

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to38 other objects

NOTICE: drop cascades to42 other objects

DROP EXTENSION pg_pathman CASCADE;

DROP SCHEMA pathman CASCADE;

(3 rows)

DROP TABLE test_bgw.test_1 CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* int8, size of Datum == 8 */

CREATE TABLE test_bgw.test_2(val INT8 NOT NULL);

SELECT create_range_partitions('test_bgw.test_2', 'val', 1, 5, 2);

(3 rows)

DROP TABLE test_bgw.test_2 CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* numeric, size of Datum == var */

CREATE TABLE test_bgw.test_3(val NUMERIC NOT NULL);

SELECT create_range_partitions('test_bgw.test_3', 'val', 1, 5, 2);

(3 rows)

DROP TABLE test_bgw.test_3 CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* date, size of Datum == var */

CREATE TABLE test_bgw.test_4(val DATE NOT NULL);

SELECT create_range_partitions('test_bgw.test_4', 'val', '20170213'::date, '1 day'::interval, 2);

(3 rows)

DROP TABLE test_bgw.test_4 CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

DROP SCHEMA test_bgw CASCADE;

DROP EXTENSION pg_pathman;

(1 row)

DROP TABLE calamity.test_range_idx CASCADE;

NOTICE: drop cascades totable calamity.test_range_idx_1

NOTICE: drop cascades to2 other objects

/* check function get_part_range_by_oid() */

CREATE TABLE calamity.test_range_oid(val INT4 NOT NULL);

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

(1 row)

DROP TABLE calamity.test_range_oid CASCADE;

NOTICE: drop cascades totable calamity.test_range_oid_1

NOTICE: drop cascades to2 other objects

/* check function merge_range_partitions() */

SELECT merge_range_partitions('{pg_class}');/* not ok */

ERROR: cannot merge partitions

calamity.merge_test_b_1}');/* not ok */

ERROR: cannot merge partitions

DROP TABLE calamity.merge_test_a,calamity.merge_test_b CASCADE;

NOTICE: drop cascades to4 other objects

NOTICE: drop cascades to6 other objects

/* check function drop_triggers() */

CREATE TABLE calamity.trig_test_tbl(val INT4 NOT NULL);

SELECT create_hash_partitions('calamity.trig_test_tbl', 'val', 2);

(3 rows)

DROP TABLE calamity.survivor CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

DROP SCHEMA calamity CASCADE;

DROP EXTENSION pg_pathman;

(1 row)

DROP TABLE callbacks.abc CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* set callback to be called on RANGE partitions */

CREATE TABLE callbacks.abc(a serial, b int);

SELECT create_range_partitions('callbacks.abc', 'a', 1, 100, 2);

INSERT INTO callbacks.abc VALUES (301, 0); /* +1 new partition */

WARNING: callback arg: {"parent": "abc", "parttype": "2", "partition": "abc_5", "range_max": "401", "range_min": "301", "parent_schema": "callbacks", "partition_schema": "callbacks"}

DROP TABLE callbacks.abc CASCADE;

NOTICE: drop cascades to4 other objects

NOTICE: drop cascades to5 other objects

/* more complex test using rotation of tables */

CREATE TABLE callbacks.abc(a INT4 NOT NULL);

INSERT INTO callbacks.abc

(4 rows)

DROP TABLE callbacks.abc CASCADE;

NOTICE: drop cascades to4 other objects

NOTICE: drop cascades to5 other objects

DROP SCHEMA callbacks CASCADE;

NOTICE: drop cascades to 2 other objects

DROP EXTENSION pg_pathman CASCADE;

(6 rows)

DROP TABLE test_cte.range_rel CASCADE;

NOTICE: drop cascades to4 other objects

NOTICE: drop cascades to5 other objects

CREATE TABLE test_cte.hash_rel (

idINT4,

valueINTEGER NOT NULL);

DROP FUNCTION test_cte.cte_del_xacts_stab(TEXT);

DROP TABLE test_cte.cte_del_xacts, test_cte.cte_del_xacts_specdata CASCADE;

NOTICE: drop cascades totable test_cte.cte_del_xacts_1

NOTICE: drop cascades to2 other objects

/* Test recursive CTE */

CREATE TABLE test_cte.recursive_cte_test_tbl(id INT NOT NULL, name TEXT NOT NULL);

SELECT create_hash_partitions('test_cte.recursive_cte_test_tbl', 'id', 2);

(1 row)

DROP SCHEMA test_exprs CASCADE;

NOTICE: drop cascades to16 other objects

NOTICE: drop cascades to17 other objects

DROP EXTENSION pg_pathman;

(3 rows)

DROP TABLE fkeys.messages, fkeys.replies CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

DROP SCHEMA fkeys CASCADE;

NOTICE: drop cascades to 2 other objects

DROP EXTENSION pg_pathman CASCADE;

INSERT INTO test_inserts.test_gap VALUES(15); /* not ok */

ERROR: cannot spawn a partition

DROP TABLE test_inserts.test_gap CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

DROP SCHEMA test_inserts CASCADE;

NOTICE: drop cascades to18 other objects

NOTICE: drop cascades to19 other objects

DROP EXTENSION pg_pathman CASCADE;

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* Range partitions for INT4 type */

CREATE TABLE test_interval.abc (id INT4 NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'id', 0, 100, 2);

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* Range partitions for INT8 type */

CREATE TABLE test_interval.abc (id INT8 NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'id', 0, 100, 2);

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to3 other objects

NOTICE: drop cascades to4 other objects

/* Range partitions for DATE type */

CREATE TABLE test_interval.abc (dt DATE NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'dt',

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* Range partitions for FLOAT4 type */

CREATE TABLE test_interval.abc (x FLOAT4 NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'x', 0, 100, 2);

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* Range partitions for FLOAT8 type */

CREATE TABLE test_interval.abc (x FLOAT8 NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'x', 0, 100, 2);

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* Range partitions for NUMERIC type */

CREATE TABLE test_interval.abc (x NUMERIC NOT NULL);

SELECT create_range_partitions('test_interval.abc', 'x', 0, 100, 2);

(1 row)

DROP TABLE test_interval.abc CASCADE;

NOTICE: drop cascades to2 other objects

NOTICE: drop cascades to3 other objects

/* Hash partitioned table shouldn't accept any interval value */

CREATE TABLE test_interval.abc (id SERIAL);

SELECT create_hash_partitions('test_interval.abc', 'id', 3);

(27 rows)

DROP SCHEMA test_only CASCADE;

NOTICE: drop cascades to11 other objects

NOTICE: drop cascades to12 other objects

DROP EXTENSION pg_pathman;