PGFILEDESC = "pg_pathman - partitioning tool"

REGRESS = pathman_basic\

pathman_inserts\

pathman_runtime_nodes\

pathman_callbacks\

pathman_domains\

ADD CONSTRAINT pathman_wrong_partition_1_check

CHECK (val < 10); /* wrong constraint */

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

ERROR:Wrong constraint format for RANGE partition "wrong_partition"

ERROR:wrong constraint format for RANGE partition "wrong_partition"

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

QUERY PLAN

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

ADD CONSTRAINT pathman_wrong_partition_1_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"

ERROR:wrong constraint format for RANGE partition "wrong_partition"

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

QUERY PLAN

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

ADD CONSTRAINT pathman_wrong_partition_1_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"

ERROR:wrong constraint format for RANGE partition "wrong_partition"

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

QUERY PLAN

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