select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

safeupdate

Require criteria for UPDATE and DELETE

pgext.cloud · Source code · License text · PGXN

Overview

Packagesafeupdate
Version1.5
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeNo DDL
Requires CREATE EXTENSIONNo
Requires preloadYes
TrustedNo
Shared librariessafeupdate
Stars153
Latest commit2026-07-13
Latest release2026-07-13
Catalogue updated2026-08-30

Related extensions

See also

pg_strictPrevent dangerous UPDATE and DELETE without WHERE clause
pg_saviorPostgres extension to save OOPS mistakes
pg_drop_eventslogs transaction ids of drop table, drop column, drop materialized view statements
table_logrecord table modification logs and PITR for table/row
block_copy_commandBlock COPY commands via a configurable ProcessUtility hook
pg_kpartReject full partition scans that omit the partition key
plan_filterfilter statements by their execution plans.