I think that when you create postgres procedure via heidi program produce incorrect create statement
PRODUCED CODE:
CREATE FUNCTION "Test2"()
RETURNS BIGINT
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY INVOKER
COMMENT E''
BEGIN
return 1
END
**************************************
CORRECT CODE:
**************************************
CREATE OR REPLACE FUNCTION public.fnctest (
)
RETURNS BIGINT AS
$body$
DECLARE
variable_name integer;
BEGIN
return 1;
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;