Postgres 13

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

select version();

version

PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

CREATE TABLE table1 (col1 int);

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

CREATE TABLE

CREATE PROCEDURE

START TRANSACTION;
INSERT INTO table1 VALUES (1);

START TRANSACTION

INSERT 0 1

/* set a savepoint we can revert to */
SAVEPOINT x;
CALL raise_error();

SAVEPOINT

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

ROLLBACK TO SAVEPOINT x;

ROLLBACK

/* now the INSERT can be committed */
COMMIT;
SELECT * FROM table1;

COMMIT

col1

1

SELECT 1