src/runtimeappend.o src/runtime_merge_append.o src/pg_pathman.o src/rangeset.o\

src/pl_funcs.o src/pl_range_funcs.o src/pl_hash_funcs.o src/pathman_workers.o\

src/hooks.o src/nodes_common.o src/xact_handling.o src/copy_stmt_hooking.o\

src/planner_tree_modification.o src/debug_print.o src/pg_compat.o$(WIN32RES)

src/planner_tree_modification.o src/debug_print.o src/pg_compat.o\

src/partition_creation.o$(WIN32RES)

EXTENSION = pg_pathman

EXTVERSION = 1.1

(3 rows)

SELECT pathman.add_range_partition('test.range_rel', '2014-12-01'::DATE, '2015-01-02'::DATE);

ERROR: specified range overlaps with existing partitions

ERROR: specified range[12-01-2014, 01-02-2015)overlaps with existing partitions

SELECT pathman.add_range_partition('test.range_rel', '2014-12-01'::DATE, '2015-01-01'::DATE);

add_range_partition

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

CREATE TABLE test.range_rel_archive (LIKE test.range_rel INCLUDING ALL);

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_archive', '2014-01-01'::DATE, '2015-01-01'::DATE);

ERROR: specified range overlaps with existing partitions

ERROR: specified range[01-01-2014, 01-01-2015)overlaps with existing partitions

SELECT pathman.attach_range_partition('test.range_rel', 'test.range_rel_archive', '2014-01-01'::DATE, '2014-12-01'::DATE);

attach_range_partition

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

4

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 4001, 5000);

check_overlap

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

t

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 4000, 5000);

check_overlap

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

t

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 3999, 5000);

check_overlap

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

t

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 3000, 3500);

check_overlap

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

t

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 0, 999);

check_overlap

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

f

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 0, 1000);

check_overlap

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

f

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 4001, 5000);

ERROR: specified range [4001, 5000) overlaps with existing partitions

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 4000, 5000);

ERROR: specified range [4000, 5000) overlaps with existing partitions

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 3999, 5000);

ERROR: specified range [3999, 5000) overlaps with existing partitions

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 3000, 3500);

ERROR: specified range [3000, 3500) overlaps with existing partitions

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 0, 999);

check_range_available

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

(1 row)

SELECT pathman.check_overlap('test.num_range_rel'::regclass::oid, 0,1001);

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

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 0,1000);

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

(1 row)

SELECT pathman.check_range_available('test.num_range_rel'::regclass, 0, 1001);

ERROR: specified range [0, 1001) overlaps with existing partitions

/* CaMeL cAsE table names and attributes */

CREATE TABLE test."TeSt" (a INT NOT NULL, b INT);

SELECT pathman.create_hash_partitions('test.TeSt', 'a', 3);

SELECT add_range_partition('test.index_on_childs', 1, 1000, 'test.index_on_childs_1_1K');

add_range_partition

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

test.index_on_childs_1_1K

test.index_on_childs_1_1k

(1 row)

SELECT append_range_partition('test.index_on_childs', 'test.index_on_childs_1K_2K');

append_range_partition

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

test.index_on_childs_1K_2K

test.index_on_childs_1k_2k

(1 row)

SELECT append_range_partition('test.index_on_childs', 'test.index_on_childs_2K_3K');

append_range_partition

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

test.index_on_childs_2K_3K

test.index_on_childs_2k_3k

(1 row)

SELECT append_range_partition('test.index_on_childs', 'test.index_on_childs_3K_4K');

append_range_partition

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

test.index_on_childs_3K_4K

test.index_on_childs_3k_4k

(1 row)

SELECT append_range_partition('test.index_on_childs', 'test.index_on_childs_4K_5K');

append_range_partition

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

test.index_on_childs_4K_5K

test.index_on_childs_4k_5k

(1 row)

SELECT set_enable_parent('test.index_on_childs', true);

(1 row)

SELECT invoke_on_partition_created_callback(NULL, 'calamity.part_test', 1);

ERROR: parent_relid should not benull

ERROR:'parent_relid' should not beNULL

SELECT invoke_on_partition_created_callback('calamity.part_test', NULL, 1);

ERROR: partition should not benull

ERROR:'partition' should not beNULL

/* check function add_to_pathman_config() -- PHASE #1 */

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

ERROR: attname should not benull

ERROR:'attname' should not beNULL

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

add_to_pathman_config

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