Postgres 13

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

CREATE TABLE table1 (col1 int);

CREATE TABLE


CREATE PROCEDURE raise_error() AS $$
BEGIN
  INSERT INTO table1 VALUES (1/0);
END;
$$ LANGUAGE plpgsql;

CREATE PROCEDURE


DO
$$
BEGIN
  INSERT INTO table1 VALUES (1);
  CALL raise_error();
END;
$$ LANGUAGE plpgsql;

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


SELECT * FROM table1;


col1



SELECT 0