Extensions
safeupdate

safeupdate

safeupdate : Require criteria for UPDATE and DELETE

Overview

ID Extension Package Version Category License Language
5820
safeupdate
safeupdate
 1.5
ADMIN
ISC
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--sL---
No
Yes
Yes
No
no
no
Relationships
See Also
pg_readonly
pg_upless
pg_savior
pg_permissions
pgaudit
set_user
login_hook
noset

pg13 breaks on debian systems

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.5
18
17
16
15
14
13
 safeupdate -
RPM
PGDG
 1.5
18
17
16
15
14
13
 safeupdate_$v* -
DEB
PIGSTY
 1.5
18
17
16
15
14
13
 postgresql-$v-pg-safeupdate -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.4
el8.aarch64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.4.2
el9.x86_64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.4.2
el9.aarch64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.4.2
el10.x86_64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
MISS
el10.aarch64
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
PGDG 1.5
MISS
d12.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
d12.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
d13.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
d13.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
u22.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
u22.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
u24.x86_64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
u24.aarch64
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
PIGSTY 1.5
MISS
Package Version OS ORG SIZE File URL
safeupdate_18 1.5 el8.x86_64 pgdg 13.4 KiB safeupdate_18-1.5-2PGDG.rhel8.x86_64.rpm
safeupdate_18 1.5 el8.aarch64 pgdg 13.4 KiB safeupdate_18-1.5-2PGDG.rhel8.aarch64.rpm
safeupdate_18 1.5 el9.x86_64 pgdg 12.8 KiB safeupdate_18-1.5-2PGDG.rhel9.x86_64.rpm
safeupdate_18 1.5 el9.aarch64 pgdg 12.6 KiB safeupdate_18-1.5-2PGDG.rhel9.aarch64.rpm
safeupdate_18 1.5 el10.x86_64 pgdg 13.2 KiB safeupdate_18-1.5-2PGDG.rhel10.x86_64.rpm
safeupdate_18 1.5 el10.aarch64 pgdg 13.2 KiB safeupdate_18-1.5-2PGDG.rhel10.aarch64.rpm
postgresql-18-pg-safeupdate 1.5 d12.x86_64 pigsty 8.7 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~bookworm_amd64.deb
postgresql-18-pg-safeupdate 1.5 d12.aarch64 pigsty 8.8 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~bookworm_arm64.deb
postgresql-18-pg-safeupdate 1.5 d13.x86_64 pigsty 8.7 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~trixie_amd64.deb
postgresql-18-pg-safeupdate 1.5 d13.aarch64 pigsty 8.8 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~trixie_arm64.deb
postgresql-18-pg-safeupdate 1.5 u22.x86_64 pigsty 8.8 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~jammy_amd64.deb
postgresql-18-pg-safeupdate 1.5 u22.aarch64 pigsty 8.9 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~jammy_arm64.deb
postgresql-18-pg-safeupdate 1.5 u24.x86_64 pigsty 9.0 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~noble_amd64.deb
postgresql-18-pg-safeupdate 1.5 u24.aarch64 pigsty 9.0 KiB postgresql-18-pg-safeupdate_1.5-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
safeupdate_17 1.5 el8.x86_64 pgdg 13.3 KiB safeupdate_17-1.5-1PGDG.rhel8.x86_64.rpm
safeupdate_17 1.5 el8.aarch64 pgdg 13.3 KiB safeupdate_17-1.5-1PGDG.rhel8.aarch64.rpm
safeupdate_17 1.5 el9.x86_64 pgdg 12.9 KiB safeupdate_17-1.5-1PGDG.rhel9.x86_64.rpm
safeupdate_17 1.5 el9.aarch64 pgdg 12.8 KiB safeupdate_17-1.5-1PGDG.rhel9.aarch64.rpm
safeupdate_17 1.5 el10.x86_64 pgdg 13.2 KiB safeupdate_17-1.5-2PGDG.rhel10.x86_64.rpm
safeupdate_17 1.5 el10.aarch64 pgdg 13.2 KiB safeupdate_17-1.5-2PGDG.rhel10.aarch64.rpm
postgresql-17-pg-safeupdate 1.5 d12.x86_64 pigsty 8.7 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~bookworm_amd64.deb
postgresql-17-pg-safeupdate 1.5 d12.aarch64 pigsty 8.7 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~bookworm_arm64.deb
postgresql-17-pg-safeupdate 1.5 d13.x86_64 pigsty 8.7 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~trixie_amd64.deb
postgresql-17-pg-safeupdate 1.5 d13.aarch64 pigsty 8.8 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~trixie_arm64.deb
postgresql-17-pg-safeupdate 1.5 u22.x86_64 pigsty 9.4 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~jammy_amd64.deb
postgresql-17-pg-safeupdate 1.5 u22.aarch64 pigsty 9.5 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~jammy_arm64.deb
postgresql-17-pg-safeupdate 1.5 u24.x86_64 pigsty 8.9 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~noble_amd64.deb
postgresql-17-pg-safeupdate 1.5 u24.aarch64 pigsty 9.0 KiB postgresql-17-pg-safeupdate_1.5-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
safeupdate_16 1.5 el8.x86_64 pgdg 13.3 KiB safeupdate_16-1.5-1PGDG.rhel8.x86_64.rpm
safeupdate_16 1.4.2 el8.x86_64 pgdg 13.4 KiB safeupdate_16-1.4.2-2PGDG.rhel8.x86_64.rpm
safeupdate_16 1.5 el8.aarch64 pgdg 13.3 KiB safeupdate_16-1.5-1PGDG.rhel8.aarch64.rpm
safeupdate_16 1.4.2 el8.aarch64 pgdg 13.4 KiB safeupdate_16-1.4.2-2PGDG.rhel8.aarch64.rpm
safeupdate_16 1.5 el9.x86_64 pgdg 12.9 KiB safeupdate_16-1.5-1PGDG.rhel9.x86_64.rpm
safeupdate_16 1.4.2 el9.x86_64 pgdg 12.9 KiB safeupdate_16-1.4.2-2PGDG.rhel9.x86_64.rpm
safeupdate_16 1.5 el9.aarch64 pgdg 12.8 KiB safeupdate_16-1.5-1PGDG.rhel9.aarch64.rpm
safeupdate_16 1.4.2 el9.aarch64 pgdg 12.6 KiB safeupdate_16-1.4.2-2PGDG.rhel9.aarch64.rpm
safeupdate_16 1.5 el10.x86_64 pgdg 13.2 KiB safeupdate_16-1.5-2PGDG.rhel10.x86_64.rpm
safeupdate_16 1.5 el10.aarch64 pgdg 13.2 KiB safeupdate_16-1.5-2PGDG.rhel10.aarch64.rpm
postgresql-16-pg-safeupdate 1.5 d12.x86_64 pigsty 8.7 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~bookworm_amd64.deb
postgresql-16-pg-safeupdate 1.5 d12.aarch64 pigsty 8.7 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~bookworm_arm64.deb
postgresql-16-pg-safeupdate 1.5 d13.x86_64 pigsty 8.7 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~trixie_amd64.deb
postgresql-16-pg-safeupdate 1.5 d13.aarch64 pigsty 8.8 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~trixie_arm64.deb
postgresql-16-pg-safeupdate 1.5 u22.x86_64 pigsty 9.4 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~jammy_amd64.deb
postgresql-16-pg-safeupdate 1.5 u22.aarch64 pigsty 9.5 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~jammy_arm64.deb
postgresql-16-pg-safeupdate 1.5 u24.x86_64 pigsty 8.9 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~noble_amd64.deb
postgresql-16-pg-safeupdate 1.5 u24.aarch64 pigsty 8.9 KiB postgresql-16-pg-safeupdate_1.5-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
safeupdate_15 1.5 el8.x86_64 pgdg 13.3 KiB safeupdate_15-1.5-1PGDG.rhel8.x86_64.rpm
safeupdate_15 1.4 el8.x86_64 pgdg 17.8 KiB safeupdate_15-1.4-1.rhel8.x86_64.rpm
safeupdate_15 1.5 el8.aarch64 pgdg 13.3 KiB safeupdate_15-1.5-1PGDG.rhel8.aarch64.rpm
safeupdate_15 1.4.2 el8.aarch64 pgdg 13.3 KiB safeupdate_15-1.4.2-1.rhel8.aarch64.rpm
safeupdate_15 1.4 el8.aarch64 pgdg 17.8 KiB safeupdate_15-1.4-1.rhel8.aarch64.rpm
safeupdate_15 1.5 el9.x86_64 pgdg 12.9 KiB safeupdate_15-1.5-1PGDG.rhel9.x86_64.rpm
safeupdate_15 1.4.2 el9.x86_64 pgdg 12.9 KiB safeupdate_15-1.4.2-1.rhel9.x86_64.rpm
safeupdate_15 1.4 el9.x86_64 pgdg 17.9 KiB safeupdate_15-1.4-1.rhel9.x86_64.rpm
safeupdate_15 1.5 el9.aarch64 pgdg 12.8 KiB safeupdate_15-1.5-1PGDG.rhel9.aarch64.rpm
safeupdate_15 1.4.2 el9.aarch64 pgdg 12.6 KiB safeupdate_15-1.4.2-1.rhel9.aarch64.rpm
safeupdate_15 1.4 el9.aarch64 pgdg 17.7 KiB safeupdate_15-1.4-1.rhel9.aarch64.rpm
safeupdate_15 1.5 el10.x86_64 pgdg 13.3 KiB safeupdate_15-1.5-2PGDG.rhel10.x86_64.rpm
safeupdate_15 1.5 el10.aarch64 pgdg 13.3 KiB safeupdate_15-1.5-2PGDG.rhel10.aarch64.rpm
postgresql-15-pg-safeupdate 1.5 d12.x86_64 pigsty 8.7 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~bookworm_amd64.deb
postgresql-15-pg-safeupdate 1.5 d12.aarch64 pigsty 8.7 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~bookworm_arm64.deb
postgresql-15-pg-safeupdate 1.5 d13.x86_64 pigsty 8.7 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~trixie_amd64.deb
postgresql-15-pg-safeupdate 1.5 d13.aarch64 pigsty 8.8 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~trixie_arm64.deb
postgresql-15-pg-safeupdate 1.5 u22.x86_64 pigsty 9.4 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~jammy_amd64.deb
postgresql-15-pg-safeupdate 1.5 u22.aarch64 pigsty 9.5 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~jammy_arm64.deb
postgresql-15-pg-safeupdate 1.5 u24.x86_64 pigsty 8.9 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~noble_amd64.deb
postgresql-15-pg-safeupdate 1.5 u24.aarch64 pigsty 8.9 KiB postgresql-15-pg-safeupdate_1.5-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
safeupdate_14 1.5 el8.x86_64 pgdg 13.3 KiB safeupdate_14-1.5-1PGDG.rhel8.x86_64.rpm
safeupdate_14 1.4 el8.x86_64 pgdg 18.3 KiB safeupdate_14-1.4-1.rhel8.x86_64.rpm
safeupdate_14 1.5 el8.aarch64 pgdg 13.3 KiB safeupdate_14-1.5-1PGDG.rhel8.aarch64.rpm
safeupdate_14 1.4.2 el8.aarch64 pgdg 13.2 KiB safeupdate_14-1.4.2-1.rhel8.aarch64.rpm
safeupdate_14 1.4 el8.aarch64 pgdg 17.7 KiB safeupdate_14-1.4-1.rhel8.aarch64.rpm
safeupdate_14 1.5 el9.x86_64 pgdg 12.9 KiB safeupdate_14-1.5-1PGDG.rhel9.x86_64.rpm
safeupdate_14 1.4.2 el9.x86_64 pgdg 12.8 KiB safeupdate_14-1.4.2-1.rhel9.x86_64.rpm
safeupdate_14 1.5 el9.aarch64 pgdg 12.8 KiB safeupdate_14-1.5-1PGDG.rhel9.aarch64.rpm
safeupdate_14 1.4.2 el9.aarch64 pgdg 12.6 KiB safeupdate_14-1.4.2-1.rhel9.aarch64.rpm
safeupdate_14 1.4 el9.aarch64 pgdg 17.6 KiB safeupdate_14-1.4-1.rhel9.aarch64.rpm
safeupdate_14 1.5 el10.x86_64 pgdg 13.3 KiB safeupdate_14-1.5-2PGDG.rhel10.x86_64.rpm
safeupdate_14 1.5 el10.aarch64 pgdg 13.3 KiB safeupdate_14-1.5-2PGDG.rhel10.aarch64.rpm
postgresql-14-pg-safeupdate 1.5 d12.x86_64 pigsty 8.7 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~bookworm_amd64.deb
postgresql-14-pg-safeupdate 1.5 d12.aarch64 pigsty 8.7 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~bookworm_arm64.deb
postgresql-14-pg-safeupdate 1.5 d13.x86_64 pigsty 8.7 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~trixie_amd64.deb
postgresql-14-pg-safeupdate 1.5 d13.aarch64 pigsty 8.8 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~trixie_arm64.deb
postgresql-14-pg-safeupdate 1.5 u22.x86_64 pigsty 9.3 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~jammy_amd64.deb
postgresql-14-pg-safeupdate 1.5 u22.aarch64 pigsty 9.5 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~jammy_arm64.deb
postgresql-14-pg-safeupdate 1.5 u24.x86_64 pigsty 8.9 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~noble_amd64.deb
postgresql-14-pg-safeupdate 1.5 u24.aarch64 pigsty 8.9 KiB postgresql-14-pg-safeupdate_1.5-2PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
safeupdate_13 1.4 el8.x86_64 pgdg 17.9 KiB safeupdate_13-1.4-1.rhel8.x86_64.rpm
safeupdate_13 1.3 el8.x86_64 pgdg 17.7 KiB safeupdate_13-1.3-1.rhel8.x86_64.rpm
safeupdate_13 1.4.2 el8.aarch64 pgdg 13.2 KiB safeupdate_13-1.4.2-1.rhel8.aarch64.rpm
safeupdate_13 1.4 el8.aarch64 pgdg 17.6 KiB safeupdate_13-1.4-1.rhel8.aarch64.rpm
safeupdate_13 1.4.2 el9.x86_64 pgdg 12.8 KiB safeupdate_13-1.4.2-1.rhel9.x86_64.rpm
safeupdate_13 1.4.2 el9.aarch64 pgdg 12.6 KiB safeupdate_13-1.4.2-1.rhel9.aarch64.rpm
safeupdate_13 1.4 el9.aarch64 pgdg 17.4 KiB safeupdate_13-1.4-1.rhel9.aarch64.rpm

Source

Repository
github.com/eradman/pg-safeupdate
 Source Tarball
pg-safeupdate-1.5.tar.gz
 
pig build pkg safeupdate;		# build spec not ready

Install

Make sure PGDG repo available:

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

Install this extension with pig:

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

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

Config this extension to shared_preload_libraries:

shared_preload_libraries = 'safeupdate';

This extension does not need CREATE EXTENSION DDL command

Last updated on
pg_saviorpg_drop_events