$$ LANGUAGE plpgsql;

CREATEOR REPLACE FUNCTION @extschema@.check_boundaries(

p_relation REGCLASS

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

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

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;

v_condTEXT;

v_plain_partnameTEXT;

v_plain_schemaTEXT;

rel_persistenceCHAR;

SELECT relpersistenceFROMpg_catalog.pg_classWHEREoid= p_partition INTO rel_persistence;

IF rel_persistence='t'::CHAR THEN

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

quote_ident(p_partition::TEXT);

END IF;

PERFORM @extschema@.acquire_partitions_lock();

END $body$ LANGUAGE plpgsql';

triggerTEXT :='CREATE TRIGGER %s_update_trigger'||

triggerTEXT :='CREATE TRIGGER %s_update_trigger'||

'FOR EACH ROW EXECUTE PROCEDURE %s_update_trigger_func()';

att_namesTEXT;