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 = #< + ); + + /*****************************************************************************

