DROP TABLE test.provided_part_names CASCADE;

NOTICE: drop cascades to 2 other objects

-- is pathman (caches, in particular) strong enough to carry out this?

-- 079797e0d5

CREATE TABLE test.part_test(val serial);

INSERT INTO test.part_test SELECT generate_series(1, 30);

SELECT create_range_partitions('test.part_test', 'val', 1, 10);

create_range_partitions

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

3

(1 row)

SELECT set_interval('test.part_test', 100);

set_interval

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

(1 row)

DELETE FROM pathman_config WHERE partrel = 'test.part_test'::REGCLASS;

SELECT drop_partitions('test.part_test');

ERROR: table "test.part_test" has no partitions

SELECT disable_pathman_for('test.part_test');

disable_pathman_for

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

(1 row)

CREATE TABLE test.wrong_partition (LIKE test.part_test) INHERITS (test.part_test);

NOTICE: merging column "val" with inherited definition

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

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

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

ERROR: wrong constraint format for HASH partition "part_test_1"

DROP TABLE test.part_test CASCADE;

NOTICE: drop cascades to 5 other objects

--

-- 85fc5ccf121

CREATE TABLE test.part_test(val serial);

INSERT INTO test.part_test SELECT generate_series(1, 3000);

SELECT create_range_partitions('test.part_test', 'val', 1, 10);

create_range_partitions

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

300

(1 row)

SELECT append_range_partition('test.part_test');

append_range_partition

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

test.part_test_301

(1 row)

DELETE FROM test.part_test;

SELECT create_single_range_partition('test.part_test', NULL::INT4, NULL);/* not ok */

ERROR: cannot create partition with range (-inf, +inf)

DELETE FROM pathman_config WHERE partrel = 'test.part_test'::REGCLASS;

SELECT create_hash_partitions('test.part_test', 'val', 2, partition_names := ARRAY[]::TEXT[]); /* not ok */

ERROR: can't partition table "test.part_test" with existing children

DROP TABLE test.part_test CASCADE;

NOTICE: drop cascades to 302 other objects

--

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to 28 other objects

DROP EXTENSION pg_pathman CASCADE;

DROPTABLEtest.provided_part_names CASCADE;

CREATETABLEtest.part_test(valserial);

INSERT INTOtest.part_testSELECT generate_series(1,30);

SELECT create_range_partitions('test.part_test','val',1,10);

SELECT set_interval('test.part_test',100);

DELETEFROM pathman_configWHERE partrel='test.part_test'::REGCLASS;

SELECT drop_partitions('test.part_test');

SELECT disable_pathman_for('test.part_test');

CREATETABLEtest.wrong_partition (LIKEtest.part_test) INHERITS (test.part_test);

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

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

DROPTABLEtest.part_test CASCADE;

CREATETABLEtest.part_test(valserial);

INSERT INTOtest.part_testSELECT generate_series(1,3000);

SELECT create_range_partitions('test.part_test','val',1,10);

SELECT append_range_partition('test.part_test');

DELETEFROMtest.part_test;

SELECT create_single_range_partition('test.part_test',NULL::INT4,NULL);/* not ok*/

DELETEFROM pathman_configWHERE partrel='test.part_test'::REGCLASS;

SELECT create_hash_partitions('test.part_test','val',2, partition_names := ARRAY[]::TEXT[]);/* not ok*/

DROPTABLEtest.part_test CASCADE;

DROPSCHEMA test CASCADE;

DROP EXTENSION pg_pathman CASCADE;