Hi Jules,<div><br></div><div>I can&#39;t manage to import your dump file. It only contains data, but not the &quot;ways&quot;.</div><div>This is how the &quot;ways&quot; table looks in the pgRouting workshop:</div><div><br>

</div><div><div><font face="&#39;courier new&#39;, monospace">CREATE TABLE ways </font><span style="font-family: &#39;courier new&#39;, monospace; ">(</span></div><div><font face="&#39;courier new&#39;, monospace">  gid integer NOT NULL,</font></div>

<div><font face="&#39;courier new&#39;, monospace">  class_id integer,</font></div><div><font face="&#39;courier new&#39;, monospace">  length double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  &quot;name&quot; character(200),</font></div>

<div><font face="&#39;courier new&#39;, monospace">  x1 double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  y1 double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  x2 double precision,</font></div>

<div><font face="&#39;courier new&#39;, monospace">  y2 double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  reverse_cost double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  &quot;rule&quot; text,</font></div>

<div><font face="&#39;courier new&#39;, monospace">  to_cost double precision,</font></div><div><font face="&#39;courier new&#39;, monospace">  the_geom geometry,</font></div><div><font face="&#39;courier new&#39;, monospace">  source integer,</font></div>

<div><font face="&#39;courier new&#39;, monospace">  target integer,</font></div><div><font face="&#39;courier new&#39;, monospace">  CONSTRAINT ways_pkey PRIMARY KEY (gid),</font></div><div><font face="&#39;courier new&#39;, monospace">  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),</font></div>

<div><font face="&#39;courier new&#39;, monospace">  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = &#39;MULTILINESTRING&#39;::text OR the_geom IS NULL),</font></div><div><font face="&#39;courier new&#39;, monospace">  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)</font></div>

<div><font face="&#39;courier new&#39;, monospace">) </font><span style="font-family: &#39;courier new&#39;, monospace; ">WITH (</span></div><div><font face="&#39;courier new&#39;, monospace">  OIDS=FALSE</font></div><div>

<font face="&#39;courier new&#39;, monospace">);</font></div><div><br></div><div><br></div></div><div><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<br><b>SELECT * from driving_distance(&#39;select gid as id,source,target,length::</b><b>double precision as cost from ways&#39;,22777838,0.01);</b><br>

<br clear="all"><span lang="en"><span>ERROR:</span> <span>function</span> <span>driving_distance</span> <span>(</span><span>&quot;unknown&quot;</span><span>, integer</span><span>, numeric</span><span>) does not exist</span><br>



 <span>HINT:</span> <span>No function</span> <span>matches the</span> <span>given name</span> <span>and</span> <span>argument types</span><span>.</span> <span>You need to add</span> <span>explicit</span> <span>type</span> <span>conversions</span><span>.<br>

</span></span></blockquote><div><br></div><div><br></div><div>There are two functions with this name that take different arguments:</div><div><a href="https://github.com/pgRouting/pgrouting/blob/master/extra/driving_distance/sql/routing_dd_wrappers.sql#L78">https://github.com/pgRouting/pgrouting/blob/master/extra/driving_distance/sql/routing_dd_wrappers.sql#L78</a></div>

<div><a href="https://github.com/pgRouting/pgrouting/blob/master/extra/driving_distance/sql/routing_dd.sql#L24">https://github.com/pgRouting/pgrouting/blob/master/extra/driving_distance/sql/routing_dd.sql#L24</a></div><div>

<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><span lang="en"><span>

<br><b>SELECT * FROM shortest_path_astar(&#39;select gid as id,source::int4,target::int4,reverse_cost::double precision as reverse_cost,x1,y1,x2,y2 from ways&#39;,22,150,false,false);</b><br>ERREUR:  Error, query must return columns &#39;id&#39;, &#39;source&#39;, &#39;target&#39; and &#39;cost&#39;<br>



<br></span></span></blockquote><div><br></div><div>There could be something wrong with your &quot;ways&quot; table, because I couldn&#39;t load the table dump either.  </div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">

<span lang="en"><span><i><b>SELECT * from tsp(&#39;select distinct source as source_id,x1::double precision as x,y1::double precision as y from ways where source in(91,35,75,504,254)&#39;,&#39;91,35,75,504,254&#39;,353);</b></i><br>

<br>

</span></span><span lang="en"><span>WARNING:</span> <span>stop</span> <span>the connection</span> <span>because of</span> <span>crash</span> <span>of another</span> <span>server process</span><br>
 <span>DETAIL:</span> <span>The</span> <span>postmaster</span> <span>has commanded</span> <span>this</span> <span>server process</span> <span>to cancel the transaction</span><br>
 <span>Current</span> <span>and leave</span> <span>because another process</span> <span>server</span> <span>left</span> <span>abnormally</span><br> <span>and there is</span> <span>probably</span> <span>corrupted</span> <span>shared memory</span><span>.</span><br>



 <span>TIP:</span> <span>In a moment</span> <span>you should be able</span> <span>to reconnect to</span> <span>the base of</span><br> <span>data and</span> <span>restart</span> <span>your order.</span><br>
 <span>the server connection</span> <span>was cut off</span> <span>unexpectedly</span><br>         <span>The server</span> <span>may have</span> <span>terminated abnormally</span> <span>before or during</span><br>
         <span>processing the request</span><span>.</span><br> <span>The</span> <span>server connection</span> <span>was lost.</span> <span>Attempting</span> <span>reset</span><span>:</span> <span>success / or sometimes not</span><span>.</span></span></blockquote>

<div><br></div><div>Have you tried one of the TSP wrapper functions?</div><div><a href="https://github.com/pgRouting/pgrouting/blob/master/extra/tsp/sql/routing_tsp_wrappers.sql">https://github.com/pgRouting/pgrouting/blob/master/extra/tsp/sql/routing_tsp_wrappers.sql</a></div>

<div><br></div><div>They take less arguments, so maybe easier to make the query correct.</div><div><br></div><div><br></div><div>Daniel</div><div><br></div></div><div><br></div>-- <br><span style="font-family:arial, sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG &amp; Georepublic Japan<br>

eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66, 99, 171)" target="_blank">daniel.kastl@georepublic.de</a><br>Web: <a href="http://georepublic.de/" style="color:rgb(66, 99, 171)" target="_blank">http://georepublic.de</a></span><br>


</div>