CREATE TABLE test.t AS SELECT 1 AS id;
-- CREATE PROCEDURE test.proc()
-- LANGUAGE plpgsql
-- AS $$
-- BEGIN
-- CALL test.proc_1();
-- RAISE EXCEPTION 'some exception raised';
-- END;$$;
-- CREATE OR REPLACE PROCEDURE test.proc_1()
-- LANGUAGE plpgsql
-- AS $$
-- BEGIN
-- UPDATE test.t SET id = id + 1;
-- COMMIT;
-- END;$$;
SELECT * FROM test.t;
-- CALL test.proc();
-- SELECT * FROM test.t;