[Mobilitydb-users] [EXTERNAL] Re: [Mobilitydb-dev] Joint release candidate 1.1 of MobilityDB, MEOS, and PyMEOS

[Wendell Turner]

Some notes about the release:

I compiled the software, stopped the database, installed the libraries, and restarted the database.  (I did not drop or re-load the extension.)

1. A simple psql query for the data shows times but no position (for the tgeogpoint type):

# select flight_index, flown_path from trajectories where opsday = '2023-12-17' limit 1;
       214741 | [""@2023-12-17 12:40:00+00, ""@2023-12-17 12:41:00+00, ""@2023-12-17 12:42:00+00, ""@2023-12-17 12:43:00+00, ...

2. bad astext() function:
# select acid, flight_index, astext(flown_path) from trajectories limit 2;
ERROR:  The temporal value must be a temporal point type

Did the name of the asText() function change?

3. In an involved query using atGeometry, it produces:
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) could not find function "Temporal_to_period" in file "/usr/local/pgsql/lib/libMobilityDB-1.1.so"

This worked previously when using MobilityDB 1.1-alpha.   Do I need to recompile psycopg2 from binaries in order to pick up this symbol?

Wendell

________________________________
From: Esteban Zimanyi <estebanzimanyi at gmail.com>
Sent: Monday, February 5, 2024 4:05 PM
To: Wendell Turner <WTurner at cssiinc.com>
Cc: Esteban Zimanyi via Mobilitydb-dev <mobilitydb-dev at lists.osgeo.org>; mobilitydb-users at lists.osgeo.org <mobilitydb-users at lists.osgeo.org>; Anita Graser <anitagraser at gmx.at>
Subject: Re: [EXTERNAL] Re: [Mobilitydb-dev] Joint release candidate 1.1 of MobilityDB, MEOS, and PyMEOS



On Mon, Feb 5, 2024 at 8:22 PM Wendell Turner <WTurner at cssiinc.com<mailto:WTurner at cssiinc.com>> wrote:
Yes, this is good news.  Glad to hear of the release.

Is the database format for v1.1.0rc1 the same as for v1.1.0-alpha?

I am almost sure this is the case but we need to run all the tests to give you a definitive answer.
It will take us some days before doing this.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mobilitydb-users/attachments/20240206/eaaa6252/attachment.htm>