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;