(3 rows)

SELECT pathman.drop_partitions('test.hash_rel');

NOTICE: function test.hash_rel_upd_trig_func() does not exist, skipping

NOTICE: 0 rows copied from test.hash_rel_0

NOTICE: 0 rows copied from test.hash_rel_1

NOTICE: 0 rows copied from test.hash_rel_2

SET pg_pathman.enable_runtimemergeappend = OFF;

VACUUM;

/* update triggers test */

SELECT pathman.create_hash_update_trigger('test.hash_rel');

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

SELECT pathman.create_update_triggers('test.hash_rel');

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

(1 row)

UPDATE test.hash_rel SET value = 7 WHERE value = 6;

6 | 7

(1 row)

SELECT pathman.create_range_update_trigger('test.num_range_rel');

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

SELECT pathman.create_update_triggers('test.num_range_rel');

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

(1 row)

UPDATE test.num_range_rel SET id = 3001 WHERE id = 1;

(6 rows)

SELECT pathman.detach_range_partition('test.range_rel_archive');

NOTICE: trigger "range_rel_upd_trig" for relation "test.range_rel_archive" does not exist, skipping

detach_range_partition

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

test.range_rel_archive

txt TEXT,

abc INTEGER);

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

ERROR: partition must havethe exact same structure as parent

ERROR: partition must havea compatible tuple format

CREATE TABLE test.range_rel_test2 (

id SERIAL PRIMARY KEY,

dt TIMESTAMP);

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

ERROR:partition must have the exact same structure as parent

ERROR:column "dt" in child table must be marked NOT NULL

/* Half open ranges */

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

add_range_partition

Indexes:

"hash_rel_0_pkey" PRIMARY KEY, btree (id)

Triggers:

hash_rel_upd_trig BEFORE UPDATE ON test.hash_rel_0 FOR EACH ROW EXECUTE PROCEDUREtest.hash_rel_upd_trig_func()

hash_rel_upd_trig BEFORE UPDATEOF valueON test.hash_rel_0 FOR EACH ROW EXECUTE PROCEDUREpathman.update_trigger_func()

\d+ test.hash_rel_extern

Table "test.hash_rel_extern"

idINTEGER NOT NULL,

valueINTEGER);

SELECT pathman.replace_hash_partition('test.hash_rel_1', 'test.hash_rel_wrong');

ERROR:partition must have the exact same structure as parent

ERROR:column "value" in child table must be marked NOT NULL

EXPLAIN (COSTS OFF) SELECT * FROM test.hash_rel;

QUERY PLAN

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

* Clean up

*/

SELECT pathman.drop_partitions('test.hash_rel');

NOTICE: drop cascades to 2 other objects

NOTICE: 3 rows copied from test.hash_rel_1

NOTICE: 2 rows copied from test.hash_rel_2

NOTICE: 2 rows copied from test.hash_rel_extern

(1 row)

SELECT pathman.drop_partitions('test.hash_rel', TRUE);

NOTICE: function test.hash_rel_upd_trig_func() does not exist, skipping

drop_partitions

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

3

DROP TABLE test.hash_rel CASCADE;

SELECT pathman.drop_partitions('test.num_range_rel');

NOTICE: drop cascades to 3 other objects

NOTICE: 998 rows copied from test.num_range_rel_1

NOTICE: 1000 rows copied from test.num_range_rel_2

NOTICE: 1000 rows copied from test.num_range_rel_3

1 | 1

(3 rows)

SELECT pathman.create_hash_update_trigger('test."TeSt"');

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

SELECT pathman.create_update_triggers('test."TeSt"');

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

(1 row)

UPDATE test."TeSt" SET a = 1;

(3 rows)

SELECT pathman.drop_partitions('test."TeSt"');

NOTICE: drop cascades to 3 other objects

NOTICE: 0 rows copied from test."TeSt_0"

NOTICE: 0 rows copied from test."TeSt_1"

NOTICE: 3 rows copied from test."TeSt_2"

1 | 1

(3 rows)

DROP TABLE test."TeSt" CASCADE;

CREATE TABLE test."RangeRel" (

idSERIAL PRIMARY KEY,

dtTIMESTAMP NOT NULL,

(1 row)

SELECT pathman.drop_partitions('test."RangeRel"');

NOTICE: function test.RangeRel_upd_trig_func() does not exist, skipping

NOTICE: 0 rows copied from test."RangeRel_1"

NOTICE: 1 rows copied from test."RangeRel_2"

NOTICE: 1 rows copied from test."RangeRel_3"

(1 row)

SELECT pathman.drop_partitions('test."RangeRel"');

NOTICE: function test.RangeRel_upd_trig_func() does not exist, skipping

NOTICE: 0 rows copied from test."RangeRel_1"

NOTICE: 0 rows copied from test."RangeRel_2"

NOTICE: 0 rows copied from test."RangeRel_3"

DELETE FROM test.range_rel r USING test.tmp t WHERE r.dt = '2010-01-02' AND r.id = t.id;

/* Create range partitions from whole range */

SELECT drop_partitions('test.range_rel');

NOTICE: function test.range_rel_upd_trig_func() does not exist, skipping

NOTICE: 44 rows copied from test.range_rel_1

NOTICE: 31 rows copied from test.range_rel_3

NOTICE: 30 rows copied from test.range_rel_4

(1 row)

SELECT drop_partitions('test.range_rel', TRUE);

NOTICE: function test.range_rel_upd_trig_func() does not exist, skipping

drop_partitions

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

10

DROP TABLE test.provided_part_names CASCADE;

NOTICE: drop cascades to 2 other objects

DROP SCHEMA test CASCADE;

NOTICE: drop cascades to49 other objects

NOTICE: drop cascades to48 other objects

DROP EXTENSION pg_pathman CASCADE;

DROP SCHEMA pathman CASCADE;

(1 row)

SELECT drop_partitions('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

NOTICE: 10 rows copied from calamity.part_test_1

NOTICE: 10 rows copied from calamity.part_test_2

NOTICE: 10 rows copied from calamity.part_test_3

(1 row)

SELECT drop_partitions('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

NOTICE: 10 rows copied from calamity.part_test_1

NOTICE: 10 rows copied from calamity.part_test_2

NOTICE: 10 rows copied from calamity.part_test_3

(1 row)

SELECT drop_partitions('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

NOTICE: 10 rows copied from calamity.part_test_1

NOTICE: 10 rows copied from calamity.part_test_2

NOTICE: 10 rows copied from calamity.part_test_3

(1 row)

SELECT drop_partitions('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

NOTICE: 10 rows copied from calamity.part_test_1

NOTICE: 10 rows copied from calamity.part_test_2

NOTICE: 10 rows copied from calamity.part_test_3

(5 rows)

SELECT drop_partitions('calamity.part_test', true);

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

drop_partitions

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

4

SELECT set_interval('calamity.part_test', 'abc'::text);/* not ok */

ERROR: invalid input syntax for integer: "abc"

SELECT drop_partitions('calamity.part_test', true);

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

drop_partitions

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

3

(1 row)

SELECT disable_pathman_for('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

disable_pathman_for

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

(1 row)

SELECT disable_pathman_for('calamity.part_test');

NOTICE: function calamity.part_test_upd_trig_func() does not exist, skipping

disable_pathman_for

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

(1 row)

SELECT disable_pathman_for('calamity.to_be_disabled'); /* should delete both rows */

NOTICE: function calamity.to_be_disabled_upd_trig_func() does not exist, skipping

disable_pathman_for

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

(1 row)

SELECT drop_partitions('callbacks.abc');

NOTICE: function callbacks.abc_upd_trig_func() does not exist, skipping

NOTICE: 0 rows copied from callbacks.abc_1

NOTICE: 1 rows copied from callbacks.abc_2

NOTICE: 1 rows copied from callbacks.abc_3

(24 rows)

SELECT drop_partitions('test_cte.cte_del_xacts'); /* now drop partitions */

NOTICE: function test_cte.cte_del_xacts_upd_trig_func() does not exist, skipping

NOTICE: 50 rows copied from test_cte.cte_del_xacts_1

NOTICE: 50 rows copied from test_cte.cte_del_xacts_2

drop_partitions

(14 rows)

SELECT drop_partitions('domains.dom_table');

NOTICE: function domains.dom_table_upd_trig_func() does not exist, skipping

NOTICE: 49 rows copied from domains.dom_table_1

NOTICE: 100 rows copied from domains.dom_table_3

NOTICE: 100 rows copied from domains.dom_table_4

ERROR: insert or update on table "test_fkey_1" violates foreign key constraint "test_fkey_1_comment_fkey"

INSERT INTO fkeys.test_fkey VALUES(1, 'test');

SELECT drop_partitions('fkeys.test_fkey');

NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping

NOTICE: 101 rows copied from fkeys.test_fkey_1

NOTICE: 100 rows copied from fkeys.test_fkey_2

NOTICE: 100 rows copied from fkeys.test_fkey_3

ERROR: insert or update on table "test_fkey_0" violates foreign key constraint "test_fkey_0_comment_fkey"

INSERT INTO fkeys.test_fkey VALUES(1, 'test');

SELECT drop_partitions('fkeys.test_fkey');

NOTICE: function fkeys.test_fkey_upd_trig_func() does not exist, skipping

NOTICE: 100 rows copied from fkeys.test_fkey_0

NOTICE: 90 rows copied from fkeys.test_fkey_1

NOTICE: 90 rows copied from fkeys.test_fkey_2

/* Finally drop partitions */

SET ROLE user1;

SELECT drop_partitions('permissions.user1_table');

NOTICE: function permissions.user1_table_upd_trig_func() does not exist, skipping

NOTICE: 10 rows copied from permissions.user1_table_1

NOTICE: 10 rows copied from permissions.user1_table_2

NOTICE: 0 rows copied from permissions.user1_table_4

INSERT INTO permissions.user2_table SELECT generate_series(1, 30);

SELECT drop_partitions('permissions.user2_table');

NOTICE: function permissions.user2_table_upd_trig_func() does not exist, skipping

NOTICE: 9 rows copied from permissions.user2_table_0

NOTICE: 11 rows copied from permissions.user2_table_1

NOTICE: 10 rows copied from permissions.user2_table_2