Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 21 Oct 2025 14:41:08 GMT
From:      Bernhard Froehlich <decke@FreeBSD.org>
To:        ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org
Subject:   git: 95880936fb19 - main - databases/pg-safeupdate: Add new port
Message-ID:  <202510211441.59LEf8t9083090@gitrepo.freebsd.org>

next in thread | raw e-mail | index | archive | help
The branch main has been updated by decke:

URL: https://cgit.FreeBSD.org/ports/commit/?id=95880936fb194458bbe156cd583c5192ca5ec39a

commit 95880936fb194458bbe156cd583c5192ca5ec39a
Author:     Lukas Engelhardt <lukas.engelhardt@gmx.de>
AuthorDate: 2025-10-21 14:39:02 +0000
Commit:     Bernhard Froehlich <decke@FreeBSD.org>
CommitDate: 2025-10-21 14:39:02 +0000

    databases/pg-safeupdate: Add new port
    
    PostgreSQL extension to block unconditional UPDATE/DELETE
    
    PR:             290229
---
 databases/Makefile                |  1 +
 databases/pg-safeupdate/Makefile  | 22 ++++++++++++++++++++++
 databases/pg-safeupdate/distinfo  |  3 +++
 databases/pg-safeupdate/pkg-descr |  4 ++++
 4 files changed, 30 insertions(+)

diff --git a/databases/Makefile b/databases/Makefile
index 9e2eaa683ef9..c72410ad7363 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -538,6 +538,7 @@
     SUBDIR += percona-orchestrator
     SUBDIR += percona-toolkit
     SUBDIR += pg-gvm
+    SUBDIR += pg-safeupdate
     SUBDIR += pg.el
     SUBDIR += pgFormatter
     SUBDIR += pg_activity
diff --git a/databases/pg-safeupdate/Makefile b/databases/pg-safeupdate/Makefile
new file mode 100644
index 000000000000..9227fd7ce1e9
--- /dev/null
+++ b/databases/pg-safeupdate/Makefile
@@ -0,0 +1,22 @@
+PORTNAME=	pg-safeupdate
+PORTVERSION=	1.5
+CATEGORIES=	databases
+PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+
+MAINTAINER=	lukas.engelhardt@gmx.de
+COMMENT=	PostgreSQL extension to block unconditional UPDATE/DELETE
+
+LICENSE=	PostgreSQL
+
+USES=		gmake pgsql
+WANT_PGSQL=	server
+
+USE_GITHUB=	yes
+GH_ACCOUNT=	eradman
+
+PLIST_FILES=	lib/postgresql/safeupdate.so
+
+post-install:
+	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/safeupdate.so
+
+.include <bsd.port.mk>
diff --git a/databases/pg-safeupdate/distinfo b/databases/pg-safeupdate/distinfo
new file mode 100644
index 000000000000..4adbb9131d76
--- /dev/null
+++ b/databases/pg-safeupdate/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1752409235
+SHA256 (eradman-pg-safeupdate-1.5_GH0.tar.gz) = 1b8742e7b2bf98275adda77cd92f5a2fd702f97d09a216c6273252894fb026f1
+SIZE (eradman-pg-safeupdate-1.5_GH0.tar.gz) = 3578
diff --git a/databases/pg-safeupdate/pkg-descr b/databases/pg-safeupdate/pkg-descr
new file mode 100644
index 000000000000..c97a51cdb3ab
--- /dev/null
+++ b/databases/pg-safeupdate/pkg-descr
@@ -0,0 +1,4 @@
+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.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202510211441.59LEf8t9083090>