Extensions
pg_statement_rollback

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
session_variablepg_dbms_metadata