<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 class="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="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="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="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="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="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="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="elementToProof"><span style="font-family: Consolas, Courier, monospace; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="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="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="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="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="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="elementToProof"><span style="font-family: Consolas, Courier, monospace; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="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="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="elementToProof"><span style="font-family: Consolas, Courier, monospace; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="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="elementToProof"><span style="font-family: Consolas, Courier, monospace; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div class="elementToProof"><span style="font-family: Consolas, Courier, monospace; font-size: 12pt; color: rgb(0, 0, 0);">Wendell</span></div>
<div class="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="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>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_gmail_quote">
<div dir="ltr" class="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_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div class="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>
</body>
</html>