INSERT INTO test_fkey VALUES(1, 'wrong');

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

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

SELECT drop_partitions('test_fkey');

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

NOTICE: 100 rows copied from test_fkey_10

NOTICE: 100 rows copied from test_fkey_4

NOTICE: 100 rows copied from test_fkey_3

NOTICE: 100 rows copied from test_fkey_2

NOTICE:100 rows copied from test_fkey_1

NOTICE:101 rows copied from test_fkey_1

drop_partitions

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

10

INSERT INTO test_fkey VALUES(1, 'wrong');

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

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

SELECT drop_partitions('test_fkey');

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

NOTICE: 94 rows copied from test_fkey_9

NOTICE: 116 rows copied from test_fkey_3

NOTICE: 90 rows copied from test_fkey_2

NOTICE: 90 rows copied from test_fkey_1

NOTICE:98 rows copied from test_fkey_0

NOTICE:100 rows copied from test_fkey_0

drop_partitions

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

10

SELECT drop_partitions('test_fkey');

SELECT create_hash_partitions('test_fkey','id',10);

INSERT INTO test_fkeyVALUES(1,'wrong');

INSERT INTO test_fkeyVALUES(1,'test');

SELECT drop_partitions('test_fkey');