DELETEFROM @extschema@.pathman_config_paramsWHERE partrel= parent_relid;

IF conf_num_del=0 THEN

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

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

END IF;

FOR v_recIN (SELECT inhrelid::regclass::textAS tbl

FOR v_recIN (SELECT inhrelid::REGCLASSAS tbl

FROMpg_catalog.pg_inherits

WHERE inhparent::regclass= parent_relid)

LOOP

IF NOT delete_data THEN

EXECUTE format('WITH part_data AS (DELETE FROM %s RETURNING *)

INSERT INTO %s SELECT * FROM part_data',

v_rec.tbl,

v_rec.tbl::TEXT,

parent_relid::text);

GET DIAGNOSTICS v_rows= ROW_COUNT;

RAISE NOTICE'% rows copied from %', v_rows,v_rec.tbl;

RAISE NOTICE'% rows copied from %', v_rows,v_rec.tbl::TEXT;

END IF;

SELECT relkindFROMpg_catalog.pg_class

WHEREoid=v_rec.tbl

INTO v_relkind;

EXECUTE format('SELECT relkind FROM pg_class WHERE oid =''%s''::regclass',v_rec.tbl)

INTO v_relkind;

IF v_relkind='f' THEN

EXECUTE format('DROP FOREIGN TABLE %s',v_rec.tbl);

EXECUTE format('DROP FOREIGN TABLE %s',v_rec.tbl::TEXT);

ELSE

EXECUTE format('DROP TABLE %s',v_rec.tbl);

EXECUTE format('DROP TABLE %s',v_rec.tbl::TEXT);

END IF;

v_part_count := v_part_count+1;

DECLARE

v_attnameTEXT;

rel_persistenceCHAR;

v_init_callbackREGPROCEDURE;

p_start_value,

p_end_value));

WITH stub_callback(stub)as (values (0))

SELECT coalesce(init_callback,0::REGPROCEDURE)

FROM stub_callback

LEFT JOIN @extschema@.pathman_config_paramsAS params

ONparams.partrel= parent_relid

INTO v_init_callback;

PERFORM @extschema@.invoke_on_partition_created_callback(parent_relid,

p_partition,

v_init_callback,

p_start_value,

p_end_value);

PERFORM @extschema@.on_update_partitions(parent_relid);

CopyStmt*copy_stmt= (CopyStmt*)parsetree;

Oidpartitioned_table;

Assert(IsPathmanReady());

if (!IsOverrideCopyEnabled())

{

elog(DEBUG1,"COPY statement hooking is disabled");

dest,completionTag);

if (is_pathman_related_copy(parsetree))

if (IsPathmanReady()&&is_pathman_related_copy(parsetree))

{

uint64processed;

uint64processed;

PathmanDoCopy((CopyStmt*)parsetree,queryString,&processed);

if (completionTag)