Hi Jules,<div><br></div><div>I can't manage to import your dump file. It only contains data, but not the "ways".</div><div>This is how the "ways" table looks in the pgRouting workshop:</div><div><br>
</div><div><div><font face="'courier new', monospace">CREATE TABLE ways </font><span style="font-family: 'courier new', monospace; ">(</span></div><div><font face="'courier new', monospace"> gid integer NOT NULL,</font></div>
<div><font face="'courier new', monospace"> class_id integer,</font></div><div><font face="'courier new', monospace"> length double precision,</font></div><div><font face="'courier new', monospace"> "name" character(200),</font></div>
<div><font face="'courier new', monospace"> x1 double precision,</font></div><div><font face="'courier new', monospace"> y1 double precision,</font></div><div><font face="'courier new', monospace"> x2 double precision,</font></div>
<div><font face="'courier new', monospace"> y2 double precision,</font></div><div><font face="'courier new', monospace"> reverse_cost double precision,</font></div><div><font face="'courier new', monospace"> "rule" text,</font></div>
<div><font face="'courier new', monospace"> to_cost double precision,</font></div><div><font face="'courier new', monospace"> the_geom geometry,</font></div><div><font face="'courier new', monospace"> source integer,</font></div>
<div><font face="'courier new', monospace"> target integer,</font></div><div><font face="'courier new', monospace"> CONSTRAINT ways_pkey PRIMARY KEY (gid),</font></div><div><font face="'courier new', monospace"> CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),</font></div>
<div><font face="'courier new', monospace"> CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL),</font></div><div><font face="'courier new', monospace"> CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)</font></div>
<div><font face="'courier new', monospace">) </font><span style="font-family: 'courier new', monospace; ">WITH (</span></div><div><font face="'courier new', monospace"> OIDS=FALSE</font></div><div>
<font face="'courier new', 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('select gid as id,source,target,length::</b><b>double precision as cost from ways',22777838,0.01);</b><br>
<br clear="all"><span lang="en"><span>ERROR:</span> <span>function</span> <span>driving_distance</span> <span>(</span><span>"unknown"</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('select gid as id,source::int4,target::int4,reverse_cost::double precision as reverse_cost,x1,y1,x2,y2 from ways',22,150,false,false);</b><br>ERREUR: Error, query must return columns 'id', 'source', 'target' and 'cost'<br>
<br></span></span></blockquote><div><br></div><div>There could be something wrong with your "ways" table, because I couldn'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('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)','91,35,75,504,254',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 & 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>