pg_statement_rollback

pg_statement_rollback : Server side rollback at statement level for PostgreSQL like Oracle or DB2

Overview

ID	Extension	Package	Version	Category	License	Language
9130	pg_statement_rollback	pg_statement_rollback	`1.4`	SIM	ISC	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--sL---	No	Yes	Yes	No	no	no

Relationships
See Also	oracle_fdw orafce pgtt session_variable safeupdate pg_dbms_metadata pg_dbms_lock pg_hint_plan

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	MIXED	`1.4`	18 17 16 15 14 13	`pg_statement_rollback`	-
RPM	PGDG	`1.5`	18 17 16 15 14 13	`pg_statement_rollback_$v*`	-
DEB	PIGSTY	`1.5`	18 17 16 15 14 13	`postgresql-$v-pg-statement-rollback`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
el8.aarch64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
el9.x86_64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
el9.aarch64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
el10.x86_64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
el10.aarch64	PGDG 1.5	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4	PGDG 1.4
d12.x86_64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
d12.aarch64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
d13.x86_64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
d13.aarch64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
u22.x86_64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
u22.aarch64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
u24.x86_64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5
u24.aarch64	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5	PIGSTY 1.5

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_18`	`1.5`	el8.x86_64	pgdg	20.1 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel8.x86_64.rpm
`pg_statement_rollback_18`	`1.5`	el8.aarch64	pgdg	19.8 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel8.aarch64.rpm
`pg_statement_rollback_18`	`1.5`	el9.x86_64	pgdg	19.5 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel9.x86_64.rpm
`pg_statement_rollback_18`	`1.5`	el9.aarch64	pgdg	19.1 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel9.aarch64.rpm
`pg_statement_rollback_18`	`1.5`	el10.x86_64	pgdg	19.8 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_18`	`1.5`	el10.aarch64	pgdg	19.8 KiB	pg_statement_rollback_18-1.5-1PGDG.rhel10.aarch64.rpm
`postgresql-18-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	28.1 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.9 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	28.1 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	28.0 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	28.5 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	28.6 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.4 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-18-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	28.4 KiB	postgresql-18-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_17`	`1.4`	el8.x86_64	pgdg	19.6 KiB	pg_statement_rollback_17-1.4-3PGDG.rhel8.x86_64.rpm
`pg_statement_rollback_17`	`1.4`	el8.aarch64	pgdg	19.5 KiB	pg_statement_rollback_17-1.4-3PGDG.rhel8.aarch64.rpm
`pg_statement_rollback_17`	`1.4`	el9.x86_64	pgdg	19.5 KiB	pg_statement_rollback_17-1.4-3PGDG.rhel9.x86_64.rpm
`pg_statement_rollback_17`	`1.4`	el9.aarch64	pgdg	19.4 KiB	pg_statement_rollback_17-1.4-3PGDG.rhel9.aarch64.rpm
`pg_statement_rollback_17`	`1.4`	el10.x86_64	pgdg	19.8 KiB	pg_statement_rollback_17-1.4-4PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_17`	`1.4`	el10.aarch64	pgdg	19.8 KiB	pg_statement_rollback_17-1.4-4PGDG.rhel10.aarch64.rpm
`postgresql-17-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	28.4 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.9 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	28.5 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	28.0 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	31.9 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	31.7 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.8 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-17-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	28.5 KiB	postgresql-17-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_16`	`1.4`	el8.x86_64	pgdg	19.5 KiB	pg_statement_rollback_16-1.4-2PGDG.rhel8.x86_64.rpm
`pg_statement_rollback_16`	`1.4`	el8.aarch64	pgdg	19.4 KiB	pg_statement_rollback_16-1.4-2PGDG.rhel8.aarch64.rpm
`pg_statement_rollback_16`	`1.4`	el9.x86_64	pgdg	19.3 KiB	pg_statement_rollback_16-1.4-2PGDG.rhel9.x86_64.rpm
`pg_statement_rollback_16`	`1.4`	el9.aarch64	pgdg	19.1 KiB	pg_statement_rollback_16-1.4-2PGDG.rhel9.aarch64.rpm
`pg_statement_rollback_16`	`1.4`	el10.x86_64	pgdg	19.8 KiB	pg_statement_rollback_16-1.4-4PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_16`	`1.4`	el10.aarch64	pgdg	19.9 KiB	pg_statement_rollback_16-1.4-4PGDG.rhel10.aarch64.rpm
`postgresql-16-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	28.4 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.9 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	28.4 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	28.0 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	31.8 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	31.7 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.8 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-16-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	28.5 KiB	postgresql-16-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_15`	`1.4`	el8.x86_64	pgdg	19.3 KiB	pg_statement_rollback_15-1.4-1.rhel8.x86_64.rpm
`pg_statement_rollback_15`	`1.3`	el8.x86_64	pgdg	36.4 KiB	pg_statement_rollback_15-1.3-1.rhel8.x86_64.rpm
`pg_statement_rollback_15`	`1.4`	el8.aarch64	pgdg	19.1 KiB	pg_statement_rollback_15-1.4-1.rhel8.aarch64.rpm
`pg_statement_rollback_15`	`1.3`	el8.aarch64	pgdg	36.2 KiB	pg_statement_rollback_15-1.3-1.rhel8.aarch64.rpm
`pg_statement_rollback_15`	`1.4`	el9.x86_64	pgdg	19.3 KiB	pg_statement_rollback_15-1.4-1.rhel9.x86_64.rpm
`pg_statement_rollback_15`	`1.3`	el9.x86_64	pgdg	37.2 KiB	pg_statement_rollback_15-1.3-1.rhel9.x86_64.rpm
`pg_statement_rollback_15`	`1.4`	el9.aarch64	pgdg	19.1 KiB	pg_statement_rollback_15-1.4-1.rhel9.aarch64.rpm
`pg_statement_rollback_15`	`1.3`	el9.aarch64	pgdg	36.9 KiB	pg_statement_rollback_15-1.3-1.rhel9.aarch64.rpm
`pg_statement_rollback_15`	`1.4`	el10.x86_64	pgdg	19.8 KiB	pg_statement_rollback_15-1.4-4PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_15`	`1.4`	el10.aarch64	pgdg	19.8 KiB	pg_statement_rollback_15-1.4-4PGDG.rhel10.aarch64.rpm
`postgresql-15-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	27.9 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.3 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	27.9 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	27.3 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	31.1 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	31.0 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.3 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-15-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	28.0 KiB	postgresql-15-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_14`	`1.4`	el8.x86_64	pgdg	19.3 KiB	pg_statement_rollback_14-1.4-1.rhel8.x86_64.rpm
`pg_statement_rollback_14`	`1.3`	el8.x86_64	pgdg	37.0 KiB	pg_statement_rollback_14-1.3-1.rhel8.x86_64.rpm
`pg_statement_rollback_14`	`1.4`	el8.aarch64	pgdg	19.1 KiB	pg_statement_rollback_14-1.4-1.rhel8.aarch64.rpm
`pg_statement_rollback_14`	`1.3`	el8.aarch64	pgdg	36.1 KiB	pg_statement_rollback_14-1.3-1.rhel8.aarch64.rpm
`pg_statement_rollback_14`	`1.4`	el9.x86_64	pgdg	19.3 KiB	pg_statement_rollback_14-1.4-1.rhel9.x86_64.rpm
`pg_statement_rollback_14`	`1.4`	el9.aarch64	pgdg	19.1 KiB	pg_statement_rollback_14-1.4-1.rhel9.aarch64.rpm
`pg_statement_rollback_14`	`1.3`	el9.aarch64	pgdg	36.8 KiB	pg_statement_rollback_14-1.3-1.rhel9.aarch64.rpm
`pg_statement_rollback_14`	`1.4`	el10.x86_64	pgdg	19.8 KiB	pg_statement_rollback_14-1.4-4PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_14`	`1.4`	el10.aarch64	pgdg	19.8 KiB	pg_statement_rollback_14-1.4-4PGDG.rhel10.aarch64.rpm
`postgresql-14-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	27.9 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.3 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	27.9 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	27.4 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	31.1 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	30.9 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.3 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-14-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	28.0 KiB	postgresql-14-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pg_statement_rollback_13`	`1.4`	el8.x86_64	pgdg	19.1 KiB	pg_statement_rollback_13-1.4-1.rhel8.x86_64.rpm
`pg_statement_rollback_13`	`1.3`	el8.x86_64	pgdg	36.8 KiB	pg_statement_rollback_13-1.3-1.rhel8.x86_64.rpm
`pg_statement_rollback_13`	`1.2`	el8.x86_64	pgdg	36.8 KiB	pg_statement_rollback_13-1.2-1.rhel8.x86_64.rpm
`pg_statement_rollback_13`	`1.4`	el8.aarch64	pgdg	19.1 KiB	pg_statement_rollback_13-1.4-1.rhel8.aarch64.rpm
`pg_statement_rollback_13`	`1.3`	el8.aarch64	pgdg	36.0 KiB	pg_statement_rollback_13-1.3-1.rhel8.aarch64.rpm
`pg_statement_rollback_13`	`1.4`	el9.x86_64	pgdg	19.3 KiB	pg_statement_rollback_13-1.4-1.rhel9.x86_64.rpm
`pg_statement_rollback_13`	`1.4`	el9.aarch64	pgdg	19.0 KiB	pg_statement_rollback_13-1.4-1.rhel9.aarch64.rpm
`pg_statement_rollback_13`	`1.3`	el9.aarch64	pgdg	36.7 KiB	pg_statement_rollback_13-1.3-1.rhel9.aarch64.rpm
`pg_statement_rollback_13`	`1.4`	el10.x86_64	pgdg	19.7 KiB	pg_statement_rollback_13-1.4-4PGDG.rhel10.x86_64.rpm
`pg_statement_rollback_13`	`1.4`	el10.aarch64	pgdg	19.8 KiB	pg_statement_rollback_13-1.4-4PGDG.rhel10.aarch64.rpm
`postgresql-13-pg-statement-rollback`	`1.5`	d12.x86_64	pigsty	27.6 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~bookworm_amd64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	d12.aarch64	pigsty	27.2 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~bookworm_arm64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	d13.x86_64	pigsty	27.6 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~trixie_amd64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	d13.aarch64	pigsty	27.3 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~trixie_arm64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	u22.x86_64	pigsty	30.8 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~jammy_amd64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	u22.aarch64	pigsty	30.5 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~jammy_arm64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	u24.x86_64	pigsty	28.0 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~noble_amd64.deb
`postgresql-13-pg-statement-rollback`	`1.5`	u24.aarch64	pigsty	27.9 KiB	postgresql-13-pg-statement-rollback_1.5-1PIGSTY~noble_arm64.deb

Source

Repository

github.com/lzlabs/pg_statement_rollback

Source Tarball

pg_statement_rollback-1.5.tar.gz

pig build pkg pg_statement_rollback;		# build spec not ready

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_statement_rollback;		# install via package name, for the active PG version

pig install pg_statement_rollback -v 18;   # install for PG 18
pig install pg_statement_rollback -v 17;   # install for PG 17
pig install pg_statement_rollback -v 16;   # install for PG 16
pig install pg_statement_rollback -v 15;   # install for PG 15
pig install pg_statement_rollback -v 14;   # install for PG 14
pig install pg_statement_rollback -v 13;   # install for PG 13

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'pg_statement_rollback';

This extension does not need CREATE EXTENSION DDL command

Last updated on 2025-11-10

session_variable pg_dbms_metadata