When INSERTing new data beyond the partitioning range, use SpawnPartitionsWorker to create new partitions in a separate transaction.

create_foreign_key(fk_table REGCLASS,

fk_attrTEXT,

pk_table REGCLASS)

Create a foreign key constraint on`fk_table` for`fk_attr` column which references partitioning key on partitioned`pk_table`.`pk_table` must have UNIQUE indexes on parent and all partitions for key column. This constraint implements RESTRICT behaviour ON DELETE and ON UPDATE actions. You can remove FK constraint regular way by performing`ALTER TABLE ... DROP CONSTRAINT ...`

INSERT INTO abc VALUES (350);

INSERT INTO xxx (abc_id) VALUES (350);

/* Partition cannot be dropped unless there are references from FK table */

/* Partition cannot be droppedor detachedunless there are references from FK table */

DROP TABLE abc_4;

ERROR: update or delete on table "abc_4" violates foreign key constraint "xxx_abc_id_fkey" on table "xxx"

SELECT detach_range_partition('abc_4');

ERROR: update or delete on table "abc_4" violates foreign key constraint "xxx_abc_id_fkey" on table "xxx"

/* Successful partition drop */

DELETE FROM xxx WHERE abc_id = 350;

DROP TABLE abc_4;

abc_x

(1 row)

/* Check replace_hash_partition() func */

ALTER TABLE xxx DROP CONSTRAINT xxx_abc_id_fkey;

DELETE FROM xxx;

SELECT drop_partitions('abc', true);

drop_partitions

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

4

(1 row)

SELECT create_hash_partitions('abc', 'id', 3);

create_hash_partitions

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

3

(1 row)

SELECT create_foreign_key('xxx', 'abc_id', 'abc');

create_foreign_key

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

(1 row)

INSERT INTO abc SELECT generate_series(1, 10);

INSERT INTO xxx (abc_id) SELECT generate_series(1, 10);

CREATE TABLE abc_x (LIKE abc INCLUDING ALL);

SELECT replace_hash_partition('abc_1', 'abc_x');

ERROR: update or delete on table "abc_1" violates foreign key constraint "xxx_abc_id_fkey" on table "xxx"

DROP EXTENSION pg_pathman CASCADE;

NOTICE: drop cascades toconstraint xxx_abc_id_fkey on table xxx

NOTICE: drop cascades to4 other objects

INTO old_constr_def;

PERFORM @extschema@.prepare_partition_drop(parent_relid, old_partition);

EXECUTE format('ALTER TABLE %s NO INHERIT %s', old_partition, parent_relid);

EXECUTE format('ALTER TABLE %s DROP CONSTRAINT %s',

old_partition,

RETURNING*)

SELECTcount(*)from config_num_deleted INTO conf_num_del;

DELETEFROM @extschema@.pathman_config_paramsWHERE partrel= parent_relid;

IF conf_num_del=0 THEN

RAISE EXCEPTION'relation "%" has no partitions', parent_relid::TEXT;

END IF;

WHEREoid=v_rec.tbl

INTO v_relkind;

PERFORM @extschema@.prepare_partition_drop(parent_relid,v_rec.tbl);

v_part_count := v_part_count+1;

END LOOP;

DELETEFROM @extschema@.pathman_config_paramsWHERE partrel= parent_relid;

PERFORM @extschema@.on_remove_partitions(parent_relid);

INSERT INTO abcVALUES (350);

INSERT INTO xxx (abc_id)VALUES (350);

DROPTABLE abc_4;

SELECT detach_range_partition('abc_4');

DELETEFROM xxxWHERE abc_id=350;

SELECT split_range_partition('abc_2',200);

SELECT add_range_partition('abc',301,401,'abc_x');

ALTERTABLE xxx DROPCONSTRAINT xxx_abc_id_fkey;

DELETEFROM xxx;

SELECT drop_partitions('abc', true);

SELECT create_hash_partitions('abc','id',3);

SELECT create_foreign_key('xxx','abc_id','abc');

INSERT INTO abcSELECT generate_series(1,10);

INSERT INTO xxx (abc_id)SELECT generate_series(1,10);

CREATETABLEabc_x (LIKE abc INCLUDING ALL);

SELECT replace_hash_partition('abc_1','abc_x');

DROP EXTENSION pg_pathman CASCADE;

#ifPG_VERSION_NUM >=90600

#ifPG_VERSION_NUM >=90600