[pgrouting-users] Re: Many errors : function driving_distance does not exist, shortest_path_astar , tps

[Daniel Kastl]

Hi Jules,

Here are working examples of your queries:

SELECT * FROM shortest_path_astar(
    'SELECT gid AS id,source::integer,target::integer,length::double
precision AS cost,x1,y1,x2,y2 FROM ways',
    300,400,false,false
);

SELECT * FROM driving_distance(
    'SELECT gid AS id,source,target,length::double precision AS cost FROM
ways',
    300,1.0,false,false
);

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',75
);

Best regards,
Daniel


On Tue, Aug 23, 2011 at 12:08 AM, Jules Kouadio <sekedoua at gmail.com> wrote:

> This is all my databse (routing).
> Please look at this.
>
>
>
> 2011/8/22 Jules Kouadio <sekedoua at gmail.com>
>
>> Hello Danniel. Thanks again for your support. I progress but i have so
>> much to learn.
>>
>> why this error for this 3 request ?*
>>
>> SELECT * from driving_distance('select gid as
>> id,source,target,length::double precision as cost from ways',22777838,0.01);
>> *
>>
>> ERROR: function driving_distance ("unknown", integer, numeric) does not
>> exist
>> HINT: No function matches the given name and argument types. You need to
>> add explicit type conversions.
>>
>> *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);*
>> ERREUR:  Error, query must return columns 'id', 'source', 'target' and
>> 'cost'
>>
>>
>> *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);*
>>
>> WARNING: stop the connection because of crash of another server process
>> DETAIL: The postmaster has commanded this server process to cancel the
>> transaction
>> Current and leave because another process server left abnormally
>> and there is probably corrupted shared memory.
>> TIP: In a moment you should be able to reconnect to the base of
>> data and restart your order.
>> the server connection was cut off unexpectedly
>>          The server may have terminated abnormally before or during
>>          processing the request.
>> The server connection was lost. Attempting reset: success / or sometimes
>> not.
>>
>>
>>
>> I don't understand why all thes errors becose shortest_path function run
>> correctly. Exple
>>
>> SELECT * FROM shortest_path('SELECT gid as
>> id,source::integer,target::integer,length::double precision as cost FROM
>> ways',300,400, false, false); give to me :
>>
>>  vertex_id | edge_id |        cost
>> -----------+---------+--------------------
>>        300 |     339 |  0.139255214687805
>>        299 |     338 |  0.179544765048058
>>        195 |     337 |  0.203993410356029
>>         63 |      56 |  0.163071365291157
>>         64 |      57 | 0.0210195901922476
>>         13 |     592 |  0.154135925931186
>>        353 |     593 |  0.167432867084967
>>        255 |     594 | 0.0922310799956524
>>        111 |     595 |  0.410249680272814
>>        435 |     596 |  0.323252439058039
>>        400 |      -1 |                  0
>> (11 lignes)
>>
>> My table "ways" is join.
>>
>>
>>
>> Thanks !
>> --
>> *
>> *
>>
>>
>>
>
>
> --
> *
> *
>
>
>


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110823/7a09d86b/attachment.html