v_part_nameTEXT;

v_intervalTEXT;

PERFORM @extschema@.acquire_partitions_lock();

SELECT attname, range_interval INTO v_attname, v_interval

FROM @extschema@.pathman_configWHERE relname::regclass= p_relation;

v_atttype := @extschema@.get_attribute_type_name(p_relation, v_attname);

PERFORM @extschema@.acquire_partitions_lock();

EXECUTE format('SELECT @extschema@.append_partition_internal($1, $2, $3, ARRAY[]::%s[])', v_atttype)

INTO v_part_name

USING p_relation, v_atttype, v_interval;

RETURN v_part_name;

EXCEPTION WHEN others THEN

PERFORM @extschema@.release_partitions_lock();

RAISE EXCEPTION'% %', SQLERRM, SQLSTATE;

PERFORM @extschema@.release_partitions_lock();

END

$$

LANGUAGE plpgsql;

v_part_nameTEXT;

v_intervalTEXT;

PERFORM @extschema@.acquire_partitions_lock();

SELECT attname, range_interval INTO v_attname, v_interval

FROM @extschema@.pathman_configWHERE relname::regclass= p_relation;

v_atttype := @extschema@.get_attribute_type_name(p_relation, v_attname);

PERFORM @extschema@.acquire_partitions_lock();

EXECUTE format('SELECT @extschema@.prepend_partition_internal($1, $2, $3, ARRAY[]::%s[])', v_atttype)

INTO v_part_name

USING p_relation, v_atttype, v_interval;

RETURN v_part_name;

EXCEPTION WHEN others THEN

PERFORM @extschema@.release_partitions_lock();

RAISE EXCEPTION'% %', SQLERRM, SQLSTATE;

PERFORM @extschema@.release_partitions_lock();

END

$$

LANGUAGE plpgsql;