Postgres 15

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

select version();
--https://stackoverflow.com/q/74192811/5298879
create table test as select 1 col1;
table test;

version

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

SELECT 1

SELECT 1

col1

1

SELECT 1

begin transaction;

do $$
declare
some_test_variable integer:=0;
begin
raise notice 'Hello from anonymous PL/pgSQL block inside a transaction. %', some_test_variable::text;
insert into test select 2; end;
$$;

table test;

BEGIN

DO

col1

1

2

SELECT 2

rollback transaction;
table test;

ROLLBACK

col1

1

SELECT 1