<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Dear Wendel</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Many thanks for your prompt tests.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Then probably my guess that you can simply recompile the application was not correct...</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I am very sorry for giving you false hopes in this regard.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Do you think that you can reload your database from scratch to enable a clean installation ?</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Many thanks for your continuous support all these years.</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Esteban</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>De :</b> Mobilitydb-users <mobilitydb-users-bounces@lists.osgeo.org> de la part de Wendell Turner via Mobilitydb-users <mobilitydb-users@lists.osgeo.org><br>
<b>Envoyé :</b> mercredi 7 février 2024 00:16<br>
<b>À :</b> Esteban Zimanyi <estebanzimanyi@gmail.com><br>
<b>Cc :</b> mobilitydb-users@lists.osgeo.org <mobilitydb-users@lists.osgeo.org><br>
<b>Objet :</b> Re: [Mobilitydb-users] [EXTERNAL] Re: [Mobilitydb-dev] Joint release candidate 1.1 of MobilityDB, MEOS, and PyMEOS</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Some notes about the release:</div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace"><br>
</span></div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace">I compiled the software, stopped the database, installed the libraries, and restarted the database. (I did not drop or re-load the extension.)</span></div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace"><br>
</span></div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace">1. A simple psql query for the data shows times but no position (for the tgeogpoint type):<br>
</span></div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<span style="font-family:Consolas,Courier,monospace"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(0,0,0)"># select flight_index, flown_path from trajectories where opsday = '2023-12-17' limit 1;<br>
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, ...</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)">2. bad astext() function:<br>
</span></div>
<div class="x_elementToProof" style="margin-left:40px"><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(0,0,0)">#
</span><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(118,62,155)">select acid, flight_index, astext(flown_path) from trajectories limit 2;</span></div>
<div class="x_elementToProof" style="margin-left:40px"><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(0,0,0)">ERROR: The temporal value must be a temporal point type</span></div>
<div class="x_elementToProof" style="margin-left:40px"><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)">Did the name of the asText() function change?</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)">3. In an involved query using atGeometry, it produces:</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:10pt; color:rgb(0,0,0)">sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedFunction) could not find function "Temporal_to_period" in file "/usr/local/pgsql/lib/libMobilityDB-1.1.so"</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)">This worked previously when using MobilityDB 1.1-alpha. Do I need to recompile psycopg2 from binaries in order to pick up this symbol?</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)"><br>
</span></div>
<div class="x_elementToProof"><span style="font-family:Consolas,Courier,monospace; font-size:12pt; color:rgb(0,0,0)">Wendell</span></div>
<div class="x_elementToProof" style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Esteban Zimanyi <estebanzimanyi@gmail.com><br>
<b>Sent:</b> Monday, February 5, 2024 4:05 PM<br>
<b>To:</b> Wendell Turner <WTurner@cssiinc.com><br>
<b>Cc:</b> Esteban Zimanyi via Mobilitydb-dev <mobilitydb-dev@lists.osgeo.org>; mobilitydb-users@lists.osgeo.org <mobilitydb-users@lists.osgeo.org>; Anita Graser <anitagraser@gmx.at><br>
<b>Subject:</b> Re: [EXTERNAL] Re: [Mobilitydb-dev] Joint release candidate 1.1 of MobilityDB, MEOS, and PyMEOS</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div dir="ltr"><br>
</div>
<br>
<div class="x_x_gmail_quote">
<div dir="ltr" class="x_x_gmail_attr">On Mon, Feb 5, 2024 at 8:22 PM Wendell Turner <<a href="mailto:WTurner@cssiinc.com">WTurner@cssiinc.com</a>> wrote:<br>
</div>
<blockquote class="x_x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="x_x_msg-3978891602127241616">
<div dir="ltr">
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Yes, this is good news. Glad to hear of the release.</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Calibri,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Is the database format for v1.1.0rc1 the same as for v1.1.0-alpha?</div>
</div>
</div>
</blockquote>
<div><br>
</div>
<div>I am almost sure this is the case but we need to run all the tests to give you a definitive answer.</div>
<div>It will take us some days before doing this. </div>
<div> </div>
</div>
</div>
</div>
</div>
</body>
</html>