<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello,</p>
<p>I'm using mobilityDB through PGAdmin and QGis (with the plugin
Move) and I have a query which works well with PGAdmin but returns
an error with Move. This query is :</p>
<pre>With bateau As (Select trip, mmsi, traj as trace from ships_3 where mmsi = 257002120)</pre>
<pre style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Select ships_3.mmsi, ships_3.traj, trace, ships_3.trip, shortestline( bateau.trip, ships_3.trip), bateau.trip |=| ships_3.trip From ships_3, bateau where dwithin(ships_3.trip, bateau.trip, 1000)</pre>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;">The error
messages are :</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span
style=" color:#000000;">2021-09-02T14:35:06 INFO </span>Error:
missing FROM-clause entry for table "ships_3"</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span
style=" color:#000000;">2021-09-02T14:35:17 INFO </span>Error:
No supported geometry types in geometry column traj</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px;
margin-right:0px; -qt-block-indent:0; text-indent:0px;"><br>
</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px;">Does someone have an idea ?
I'm running mobilityDB 1.0beta3 on docker, with Move v0.1. The
column traj is of type geometry and trip is tgeompoint. <br>
</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px;"><br>
</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px;">Best Regards,</p>
<p style="-qt-paragraph-type:empty; margin-top:0px;
margin-bottom:0px; margin-left:0px; margin-right:0px;
-qt-block-indent:0; text-indent:0px;">A. Suc<br>
</p>
</body>
</html>