Package: release.debian.org
Severity: normal
Tags: trixie
X-Debbugs-Cc: [email protected]
Control: affects -1 + src:mobilitydb
User: [email protected]
Usertags: pu

Please accept mobilitydb into trixie.

[ Reason ]
The current PostgreSQL version 17.12 got stricter in validating
operators created. The update fixes preexisting problems that are now
fatal.

[ Impact ]
Users cannot create new mobilitydb instances.

[ Tests ]
Upstream testsuite and manual testing.

[ Checklist ]
  [x] *all* changes are documented in the d/changelog
  [x] I reviewed all changes and I approve them
  [x] attach debdiff against the package in (old)stable
  [x] the issue is verified as fixed in unstable

Christoph

diff --git a/debian/changelog b/debian/changelog
index b00a448..4c66217 100644
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,11 @@
+mobilitydb (1.2.0-2+deb13u1) trixie; urgency=medium
+
+  * Remove COMMUTATOR from *(date, datespanset) operators to fix loading the
+    extension in PG 18.7 and 17.12.
+  * The commutator of #> is #<, not #<=.
+
+ -- Christoph Berg <[email protected]>  Wed, 11 Nov 2026 16:52:33 +0100
+
 mobilitydb (1.2.0-2) unstable; urgency=medium

   [ Bradford D. Boyle ]
diff --git a/debian/patches/series b/debian/patches/series
index 5f3639c..f617ace 100644
--- a/debian/patches/series
+++ b/debian/patches/series
@@ -1,2 +1,4 @@
 generate-configure-file-in-build-dir
 improve-npoint-tests.patch
+spanset_ops
+temporal_compops
diff --git a/debian/patches/spanset_ops b/debian/patches/spanset_ops
new file mode 100644
index 0000000..10ff178
--- /dev/null
+++ b/debian/patches/spanset_ops
@@ -0,0 +1,30 @@
+Remove COMMUTATOR from *(date, datespanset) operators
+
+The datatype of one of the underlying functions is wrong, and PG 18.7 refuses
+to load the extension now. A proper fix needs writing upgrade scripts, we just
+work around for now.
+
+--- a/mobilitydb/sql/general/009_spanset_ops.in.sql
++++ b/mobilitydb/sql/general/009_spanset_ops.in.sql
+@@ -2516,8 +2516,8 @@ CREATE FUNCTION span_intersection(datesp
+
+ CREATE OPERATOR * (
+   PROCEDURE = span_intersection,
+-  LEFTARG = date, RIGHTARG = datespanset,
+-  COMMUTATOR = *
++  LEFTARG = date, RIGHTARG = datespanset
++  -- COMMUTATOR = *
+ );
+ CREATE OPERATOR * (
+   PROCEDURE = span_intersection,
+@@ -2526,8 +2526,8 @@ CREATE OPERATOR * (
+ );
+ CREATE OPERATOR * (
+   PROCEDURE = span_intersection,
+-  LEFTARG = datespanset, RIGHTARG = date,
+-  COMMUTATOR = *
++  LEFTARG = datespanset, RIGHTARG = date
++  -- COMMUTATOR = *
+ );
+ CREATE OPERATOR * (
+   PROCEDURE = span_intersection,
diff --git a/debian/patches/temporal_compops b/debian/patches/temporal_compops
new file mode 100644
index 0000000..f73c85d
--- /dev/null
+++ b/debian/patches/temporal_compops
@@ -0,0 +1,25 @@
+The commutator of #> is #<, not #<=.
+
+--- a/mobilitydb/sql/general/030_temporal_compops.in.sql
++++ b/mobilitydb/sql/general/030_temporal_compops.in.sql
+@@ -1804,17 +1804,17 @@ CREATE FUNCTION temporal_tgt(ttext, ttex
+ CREATE OPERATOR #> (
+   PROCEDURE = temporal_tgt,
+   LEFTARG = text, RIGHTARG = ttext,
+-  COMMUTATOR = #<=
++  COMMUTATOR = #<
+ );
+ CREATE OPERATOR #> (
+   PROCEDURE = temporal_tgt,
+   LEFTARG = ttext, RIGHTARG = text,
+-  COMMUTATOR = #<=
++  COMMUTATOR = #<
+ );
+ CREATE OPERATOR #> (
+   PROCEDURE = temporal_tgt,
+   LEFTARG = ttext, RIGHTARG = ttext,
+-  COMMUTATOR = #<=
++  COMMUTATOR = #<
+ );
+
+ /*****************************************************************************

Reply via email to