Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table1 (col1 int);
CREATE PROCEDURE raise_error() AS $$
BEGIN
  INSERT INTO table1 VALUES (1/0);
END;
$$ LANGUAGE plpgsql;
BEGIN TRANSACTION; -- disable auto-commit
INSERT INTO table1 VALUES (1);
1 rows affected

CALL raise_error();
ERROR:  division by zero
CONTEXT:  SQL statement "INSERT INTO table1 VALUES (1/0)"
PL/pgSQL function raise_error() line 3 at SQL statement


COMMIT;
SELECT * FROM table1;