notbug ipv6 ready As an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details
pg-safeupdate PostgreSQL extension to block unconditional UPDATE/DELETE
1.5 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 1.5Version of this port present on the latest quarterly branch.
Maintainer: develuke@gmx.de search for ports maintained by this maintainer
Port Added: 2025-10-21 14:42:06
Last Update: 2026-05-25 16:46:21
Commit Hash: f5a0135
License: PostgreSQL
WWW:
https://github.com/eradman/pg-safeupdate/
Description:
Safeupdate is a simple extension to PostgreSQL that raises an error if UPDATE and DELETE are executed without specifying conditions. This extension was initially designed to protect data from accidental obliteration of data that is writable by PostgREST.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (4 items)
Collapse this list.
  1. lib/postgresql/safeupdate.so
  2. /usr/local/share/licenses/postgresql18-pg-safeupdate-1.5/catalog.mk
  3. /usr/local/share/licenses/postgresql18-pg-safeupdate-1.5/LICENSE
  4. /usr/local/share/licenses/postgresql18-pg-safeupdate-1.5/PostgreSQL
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • postgresql18-pg-safeupdate>0:databases/pg-safeupdate
To install the port:
cd /usr/ports/databases/pg-safeupdate/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pg-safeupdate
  • pkg install postgresql18-pg-safeupdate
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql18-pg-safeupdate
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1752409235 SHA256 (eradman-pg-safeupdate-1.5_GH0.tar.gz) = 1b8742e7b2bf98275adda77cd92f5a2fd702f97d09a216c6273252894fb026f1 SIZE (eradman-pg-safeupdate-1.5_GH0.tar.gz) = 3578

Packages (timestamps in pop-ups are UTC):
postgresql18-pg-safeupdate
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest1.51.5--1.5n/an/an/a
FreeBSD:13:quarterly1.51.5--1.5n/an/an/a
FreeBSD:14:latest1.51.5--1.5---
FreeBSD:14:quarterly1.51.5--1.5---
FreeBSD:15:latest1.51.5n/a-n/an/a--
FreeBSD:15:quarterly1.51.5n/a-n/an/a--
FreeBSD:16:latest1.51.5n/a-n/an/a--
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql18-server
Runtime dependencies:
  1. postgres : databases/postgresql18-server
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_pg-safeupdate
USES:
gmake pgsql
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/eradman/pg-safeupdate/tar.gz/1.5?dummy=/
Collapse this list.

Number of commits found: 2

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.5
25 May 2026 16:46:21
commit hash: f5a01351c3664523ec7d8bfc49a843531ed89f9ecommit hash: f5a01351c3664523ec7d8bfc49a843531ed89f9ecommit hash: f5a01351c3664523ec7d8bfc49a843531ed89f9ecommit hash: f5a01351c3664523ec7d8bfc49a843531ed89f9e files touched by this commit
Bernhard Froehlich (decke) search for other commits by this committer
*/*: Change maintainer EMail address for Lukas Engelhardt

Submitted by:	private email (verified off site)
1.5
21 Oct 2025 14:39:02
commit hash: 95880936fb194458bbe156cd583c5192ca5ec39acommit hash: 95880936fb194458bbe156cd583c5192ca5ec39acommit hash: 95880936fb194458bbe156cd583c5192ca5ec39acommit hash: 95880936fb194458bbe156cd583c5192ca5ec39a files touched by this commit
Bernhard Froehlich (decke) search for other commits by this committer
Author: Lukas Engelhardt
databases/pg-safeupdate: Add new port

PostgreSQL extension to block unconditional UPDATE/DELETE

PR:		290229

Number of commits found: 2