On Wed, May 29 2024, Stuart Henderson wrote:

>
> Alternatively, you could keep GH_* and just use DIST_TUPLE for the
> timescaledb-extras distfile, then portroach should still be able to
> detect updates (which it doesn't with DIST_TUPLE).
>

I didn't know it's possible to mix GH_* and DIST_TUPLE. I updated the
diff with that. Thanks :)

diff --git a/databases/timescaledb/Makefile b/databases/timescaledb/Makefile
index 46389fd2322..365eefecdbe 100644
--- a/databases/timescaledb/Makefile
+++ b/databases/timescaledb/Makefile
@@ -2,7 +2,10 @@ COMMENT =	database designed to make SQL scalable for time-series data
 
 GH_ACCOUNT =	timescale
 GH_PROJECT =	timescaledb
-GH_TAGNAME =	2.14.2
+GH_TAGNAME =	2.15.1
+
+EXTRAS_COMMIT =	52443a469a58d3f64a4e049889f468e8a149cc8f
+DIST_TUPLE +=	github timescale timescaledb-extras ${EXTRAS_COMMIT} _extras
 
 CATEGORIES =	databases
 HOMEPAGE =	https://www.timescale.com/
@@ -15,7 +18,7 @@ PERMIT_PACKAGE = Yes
 MODULES =	devel/cmake
 SUBST_VARS +=	GH_TAGNAME
 
-WANTLIB =	c crypto pq ssl
+WANTLIB =	crypto pq ssl
 
 COMPILER =	base-clang ports-gcc
 
@@ -29,4 +32,10 @@ CONFIGURE_ARGS +=	-DREGRESS_CHECKS=OFF \
 			-DSEND_TELEMETRY_DEFAULT=OFF \
 			-DCMAKE_DISABLE_FIND_PACKAGE_Git=ON
 
+post-install:
+	${INSTALL_DATA_DIR} ${PREFIX}/share/timescaledb
+	${INSTALL_DATA} \
+		${WRKSRC}/_extras/utils/2.15.X-fix_hypertable_foreign_keys.sql \
+		${PREFIX}/share/timescaledb
+
 .include <bsd.port.mk>
diff --git a/databases/timescaledb/distinfo b/databases/timescaledb/distinfo
index a0e20a0d44b..b73abd97444 100644
--- a/databases/timescaledb/distinfo
+++ b/databases/timescaledb/distinfo
@@ -1,2 +1,4 @@
-SHA256 (timescaledb-2.14.2.tar.gz) = x3aLJn6meRTQSRso2hAvrs0xcGDkKbLadTBRf7yU5zs=
-SIZE (timescaledb-2.14.2.tar.gz) = 7319288
+SHA256 (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = /fBZ0+p3BcPYlmf7Oj4cqXKF19YpWJaywrt0qGuZqvw=
+SHA256 (timescaledb-2.15.1.tar.gz) = IOLdxPtzaN61soxnilTj5gk7nA8dyghy0LbIkk6IWEo=
+SIZE (timescale-timescaledb-extras-52443a469a58d3f64a4e049889f468e8a149cc8f.tar.gz) = 12981
+SIZE (timescaledb-2.15.1.tar.gz) = 7434713
diff --git a/databases/timescaledb/pkg/MESSAGE b/databases/timescaledb/pkg/MESSAGE
new file mode 100644
index 00000000000..d422a212a3d
--- /dev/null
+++ b/databases/timescaledb/pkg/MESSAGE
@@ -0,0 +1,3 @@
+If you are upgrading from versions prior to 2.15.0, after you run 'ALTER
+EXTENSION', you must also run this SQL script:
+${PREFIX}/share/timescaledb/2.15.X-fix_hypertable_foreign_keys.sql
diff --git a/databases/timescaledb/pkg/PLIST b/databases/timescaledb/pkg/PLIST
index 5f2f8860e11..928cb177737 100644
--- a/databases/timescaledb/pkg/PLIST
+++ b/databases/timescaledb/pkg/PLIST
@@ -18,6 +18,8 @@ share/postgresql/extension/timescaledb--2.13.0--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.13.1--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.14.0--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.14.1--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.14.2--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.15.0--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.2.0--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.2.1--${GH_TAGNAME}.sql
@@ -41,3 +43,5 @@ share/postgresql/extension/timescaledb--2.9.1--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.9.2--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.9.3--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb.control
+share/timescaledb/
+share/timescaledb/2.15.X-fix_hypertable_foreign_keys.sql

-- 
Renato Aguiar

• timescaledb.patch (3K)