(1 row)

DELETE FROM calamity.part_test;

/* check function build_hash_condition() */

SELECT build_hash_condition('int4', 'val', 10, 1);

build_hash_condition

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

public.get_hash_part_idx(hashint4(val), 10) = 1

(1 row)

SELECT build_hash_condition('text', 'val', 10, 1);

build_hash_condition

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

public.get_hash_part_idx(hashtext(val), 10) = 1

(1 row)

SELECT build_hash_condition('int4', 'val', 1, 1);

ERROR: 'partition_index' must be lower than 'partitions_count'

SELECT build_hash_condition('int4', 'val', 10, 20);

ERROR: 'partition_index' must be lower than 'partitions_count'

SELECT build_hash_condition('text', 'val', 10, NULL) IS NULL;

?column?

----------

t

(1 row)

SELECT build_hash_condition('calamity.part_test', 'val', 10, 1);

ERROR: no hash function for type calamity.part_test

/* check function build_range_condition() */

SELECT build_range_condition('calamity.part_test', 'val', 10, 20);

build_range_condition

SELECT build_check_constraint_name('calamity.part_test', 1::int2);

build_check_constraint_name

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

(1 row)

SELECT build_check_constraint_name('calamity.part_test', NULL::int2) IS NULL;

SELECT build_check_constraint_name('calamity.part_test', 'val');

build_check_constraint_name

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

(1 row)

SELECT build_check_constraint_name('calamity.part_test', NULL::text) IS NULL;

SELECT add_to_pathman_config(NULL, 'val');/* no table */

ERROR: 'parent_relid' should not be NULL

SELECT add_to_pathman_config('calamity.part_test', NULL);/* no column */

ERROR: 'attname' should not be NULL

ERROR: 'expression' should not be NULL

SELECT add_to_pathman_config('calamity.part_test', 'V_A_L');/* wrong column */

ERROR:relation "part_test" has no column "V_A_L"

ERROR:Cannot find type name for attribute "v_a_l" of relation "part_test"

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

add_to_pathman_config

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

CREATE TABLE calamity.wrong_partition (LIKE calamity.part_test) INHERITS (calamity.part_test); /* wrong partition w\o constraints */

NOTICE: merging column "val" with inherited definition

SELECT add_to_pathman_config('calamity.part_test', 'val');

ERROR: constraint "pathman_wrong_partition_1_check" of partition "wrong_partition" does not exist

ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist

EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */

QUERY PLAN

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

(5 rows)

SELECT add_to_pathman_config('calamity.part_test', 'val', '10');

ERROR: constraint "pathman_wrong_partition_1_check" of partition "wrong_partition" does not exist

ERROR: constraint "pathman_wrong_partition_check" of partition "wrong_partition" does not exist

EXPLAIN (COSTS OFF) SELECT * FROM calamity.part_ok; /* check that pathman is enabled */

QUERY PLAN

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

(5 rows)

ALTER TABLE calamity.wrong_partition

ADD CONSTRAINTpathman_wrong_partition_1_check

ADD CONSTRAINTpathman_wrong_partition_check

CHECK (val = 1 OR val = 2); /* wrong constraint */

SELECT add_to_pathman_config('calamity.part_test', 'val', '10');

ERROR: wrong constraint format for RANGE partition "wrong_partition"

-> Seq Scan on part_ok_3

(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINTpathman_wrong_partition_1_check;

ALTER TABLE calamity.wrong_partition DROP CONSTRAINTpathman_wrong_partition_check;

ALTER TABLE calamity.wrong_partition

ADD CONSTRAINTpathman_wrong_partition_1_check

ADD CONSTRAINTpathman_wrong_partition_check

CHECK (val >= 10 AND val = 2); /* wrong constraint */

SELECT add_to_pathman_config('calamity.part_test', 'val', '10');

ERROR: wrong constraint format for RANGE partition "wrong_partition"

-> Seq Scan on part_ok_3

(5 rows)

ALTER TABLE calamity.wrong_partition DROP CONSTRAINTpathman_wrong_partition_1_check;

ALTER TABLE calamity.wrong_partition DROP CONSTRAINTpathman_wrong_partition_check;

/* check GUC variable */

SHOW pg_pathman.enable;

pg_pathman.enable

INSERT INTO test_interval.abc VALUES (250);

SELECT * FROM pathman_config;

partrel | attname | parttype | range_interval

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

test_interval.abc | id | 2 | 1000

partrel | attname | parttype | range_interval| expression_p | atttype

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

test_interval.abc | id | 2 | 1000 | {VAR :varno 1 :varattno 1 :vartype 21 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 8} | 21

(1 row)

DROP TABLE test_interval.abc CASCADE;

INSERT INTO test_interval.abc VALUES (250);

SELECT * FROM pathman_config;

partrel | attname | parttype | range_interval

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

test_interval.abc | id | 2 | 1000

partrel | attname | parttype | range_interval| expression_p | atttype

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

test_interval.abc | id | 2 | 1000 | {VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 8} | 23

(1 row)

DROP TABLE test_interval.abc CASCADE;

INSERT INTO test_interval.abc VALUES (250);

SELECT * FROM pathman_config;

partrel | attname | parttype | range_interval

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

test_interval.abc | id | 2 | 1000

partrel | attname | parttype | range_interval| expression_p | atttype

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

test_interval.abc | id | 2 | 1000 | {VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 8} | 20

(1 row)

DROP TABLE test_interval.abc CASCADE;

(1 row)

SELECT * FROM pathman_config;

partrel | attname | parttype | range_interval

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

test_interval.abc | dt | 2 | @ 1 mon

partrel | attname | parttype | range_interval| expression_p | atttype

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

test_interval.abc | dt | 2 | @ 1 mon | {VAR :varno 1 :varattno 1 :vartype 1082 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 8} | 1082

(1 row)

DROP TABLE test_interval.abc CASCADE;

/* Should be able to see */

SET ROLE user2;

SELECT * FROM pathman_config;

partrel | attname | parttype | range_interval

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

permissions.user1_table | id | 2 | 10

partrel | attname | parttype | range_interval| expression_p | atttype

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

permissions.user1_table | id | 2 | 10 | {VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 8} | 23

(1 row)

SELECT * FROM pathman_config_params;

/* COPY FROM (partitioned column is not specified) */

COPY copy_stmt_hooking.test(comment) FROM stdin;

ERROR:partitioned column's value should not be NULL

ERROR:partition expression's value should not be NULL

/* COPY FROM (we don't support FREEZE) */

COPY copy_stmt_hooking.test FROM stdin WITH (FREEZE);

ERROR: freeze is not supported for partitioned tables

a | integer | not null default nextval('rename.test_a_seq'::regclass) | plain | |

b | integer | | plain | |

Check constraints:

"pathman_test_one_1_check" CHECK (get_hash_part_idx(hashint4(a), 3) = 0)

"pathman_test_one_check" CHECK (get_hash_part_idx(hashint4(a), 3) = 0)

Inherits: rename.test

/* Generates check constraint for relation */

a | integer | not null default nextval('rename.test_a_seq'::regclass) | plain | |

b | integer | | plain | |

Check constraints:

"pathman_test_inh_1_1_check" CHECK (a < 100)

"pathman_test_inh_1_check" CHECK (a < 100)

Inherits: rename.test_inh

/* Check that plain tables are not affected too */

a | integer | not null default nextval('rename.plain_test_a_seq'::regclass) | plain | |

b | integer | | plain | |

Check constraints:

"pathman_plain_test_renamed_1_check" CHECK (a < 100)

"pathman_plain_test_renamed_check" CHECK (a < 100)

ALTER TABLE rename.plain_test_renamed RENAME TO plain_test;

\d+ rename.plain_test

a | integer | not null default nextval('rename.plain_test_a_seq'::regclass) | plain | |

b | integer | | plain | |

Check constraints:

"pathman_plain_test_renamed_1_check" CHECK (a < 100)

"pathman_plain_test_renamed_check" CHECK (a < 100)

DROP SCHEMA rename CASCADE;

NOTICE: drop cascades to 7 other objects

DELETEFROMcalamity.part_test;

SELECT build_hash_condition('int4','val',10,1);

SELECT build_hash_condition('text','val',10,1);

SELECT build_hash_condition('int4','val',1,1);

SELECT build_hash_condition('int4','val',10,20);

SELECT build_hash_condition('text','val',10,NULL) ISNULL;

SELECT build_hash_condition('calamity.part_test','val',10,1);

SELECT build_range_condition('calamity.part_test','val',10,20);

SELECT build_range_condition('calamity.part_test','val',10,NULL);

EXPLAIN (COSTS OFF)SELECT*FROMcalamity.part_ok;/* check that pathman is enabled*/

ALTERTABLEcalamity.wrong_partition

ADDCONSTRAINTpathman_wrong_partition_1_check

ADDCONSTRAINTpathman_wrong_partition_check

CHECK (val=1OR val=2);/* wrong constraint*/

SELECT add_to_pathman_config('calamity.part_test','val','10');

EXPLAIN (COSTS OFF)SELECT*FROMcalamity.part_ok;/* check that pathman is enabled*/

ALTERTABLEcalamity.wrong_partition DROPCONSTRAINTpathman_wrong_partition_1_check;

ALTERTABLEcalamity.wrong_partition DROPCONSTRAINTpathman_wrong_partition_check;

ALTERTABLEcalamity.wrong_partition

ADDCONSTRAINTpathman_wrong_partition_1_check

ADDCONSTRAINTpathman_wrong_partition_check

CHECK (val>=10AND val=2);/* wrong constraint*/

SELECT add_to_pathman_config('calamity.part_test','val','10');

EXPLAIN (COSTS OFF)SELECT*FROMcalamity.part_ok;/* check that pathman is enabled*/

ALTERTABLEcalamity.wrong_partition DROPCONSTRAINTpathman_wrong_partition_1_check;

ALTERTABLEcalamity.wrong_partition DROPCONSTRAINTpathman_wrong_partition_check;

SHOWpg_pathman.enable;