Prevent dangerous UPDATE and DELETE without WHERE clause
pgext.cloud · Source code · Control file
| Package | pg_strict |
|---|---|
| Version | 1.0.5 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | Preloaded |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | No |
| Shared libraries | pg_strict |
| Stars | 19 |
| Latest commit | 2026-02-18 |
| Latest release | 2026-02-18 |
| Catalogue updated | 2026-08-30 |
| safeupdate | Require criteria for UPDATE and DELETE |
| pg_savior | Postgres extension to save OOPS mistakes |
| pg_drop_events | logs transaction ids of drop table, drop column, drop materialized view statements |
| table_log | record table modification logs and PITR for table/row |
| block_copy_command | Block COPY commands via a configurable ProcessUtility hook |
| pg_kpart | Reject full partition scans that omit the partition key |
| plan_filter | filter statements by their execution plans. |