notbugAs 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 photosAll times are UTC
Ukraine
I started running short on disk space for the non-production FreshPorts hosts. This time, I have decided to ask for donations. See my recent blog post which points to my Patreon account.
Port details
pg-safeupdate PostgreSQL extension to block unconditional UPDATE/DELETE
1.5 databasesnew! 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 Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: lukas.engelhardt@gmx.de search for ports maintained by this maintainer
Port Added: 2025-10-21 14:42:06
Last Update: 2025-10-21 14:39:02
Commit Hash: 9588093
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/postgresql17-pg-safeupdate-1.5/catalog.mk
  3. /usr/local/share/licenses/postgresql17-pg-safeupdate-1.5/LICENSE
  4. /usr/local/share/licenses/postgresql17-pg-safeupdate-1.5/PostgreSQL
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • postgresql17-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 postgresql17-pg-safeupdate
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: postgresql17-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

No package information for this port in our database
Sometimes this happens. Not all ports have packages. This is doubly so for new ports, like this one.
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/postgresql17-server
Runtime dependencies:
  1. postgres : databases/postgresql17-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: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
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: 1