Procedures cannot have START TRANSACTION and SAVEPOINT

Copy SQL

SELECT 
  pg_namespace.nspname AS proc_schema, 
  pg_proc.proname AS proc_name, 
  pg_get_function_identity_arguments(pg_proc.oid) AS parameters,
  regexp_replace( regexp_replace(pg_get_functiondef(pg_proc.oid),'<','&lt','g'),'[\r\n]','<br>','g')  AS proc_src
FROM  
  pg_catalog.pg_proc, 
  pg_catalog.pg_namespace
WHERE 
  pg_proc.pronamespace = pg_namespace.oid 
  AND pg_proc.prokind='p' 
  AND pg_proc.proname NOT IN ('f_assume_you_must_use_files', 'f_check_format_comma_separated_list', 'f_check_password', 'f_default_value_with_no_match') 
  AND pg_namespace.nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND pg_get_functiondef(pg_proc.oid)~*'START[[:space:]]+TRANSACTION|SAVEPOINT[[:space:]]+'
ORDER BY proc_schema, proc_name, parameters;