PERFORM @extschema@.partition_data(parent_relid);

RETURN partitions_count;

EXCEPTION WHEN others THEN

RAISE EXCEPTION'%', SQLERRM;

END

$$ LANGUAGE plpgsql

SET client_min_messages= WARNING;

DECLARE

v_recRECORD;

is_referencedBOOLEAN;

rel_persistenceCHAR;

SELECT relpersistenceFROMpg_catalog.pg_class

WHEREoid= p_relation INTO rel_persistence;

IF rel_persistence='t'::CHAR THEN

RAISE EXCEPTION'Temporary table "%" cannot be partitioned',

quote_ident(p_relation::TEXT);

END IF;

IF EXISTS (SELECT*FROM @extschema@.pathman_config

WHERE partrel= p_relation) THEN

RAISE EXCEPTION'Relation "%" has already been partitioned', p_relation;

WHEREoid= p_partition INTO rel_persistence;

IF rel_persistence='t'::CHAR THEN

RAISE EXCEPTION'Temporary table\"%\" cannot be used as a partition',

RAISE EXCEPTION'Temporary table"%" cannot be used as a partition',

quote_ident(p_partition::TEXT);

END IF;