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