create or replace procedure development.my_test (a int, b int)
LANGUAGE plpgsql
AS $$
declare
  l_i int;
BEGIN
  l_i := a + b;
  insert into development.parti_1 (c1,c2,c3) values ('1',l_i,'1');
end
$$;

create or replace procedure development.my_test_loop ()
LANGUAGE plpgsql
AS $$
declare
 a int := 1;
BEGIN
  for i in 1..10 loop
    execute 'call development.my_test ($1, $2);' using a, i;
    commit;
  end loop;
end
$$
SECURITY INVOKER;

psql (11.5)
Введите "help", чтобы получить справку.

ddb=# call development.my_test_loop();
ERROR:  invalid transaction termination
КОНТЕКСТ:  PL/pgSQL function development.my_test_loop() line 9 at COMMIT