[pgadmin-support] pgr_createTopology creates bad topology

[Ferjo]

Hi,

I want to calculate the shortest way between two points using pgr_dijkstra
function. When I excecute that function, it doesn't show anything. Only when
two points are just in front of each other, pgr_dijkstra shows the way it is
between them. Just in this last case, pgr_dijkstra works fine. But when the
calculation is more complex, pgr_dijkstra does nothing.

I made a lot of tries and I am sure that pgr_createTopology doesn't work as
it should. Maybe my table needs more fields to get its topology done well,
but I don´t know what.

An explanation about what fields are needed for pgr_createTopology would be
helpful too.

I attach two screenshots: how it built the table's topology and its fields
composition.

Thank you very much!

 

 



--
View this message in context: 
http://postgresql.nabble.com/pgr-createTopology-creates-bad-topology-tp5925751.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] pgr_createTopology creates bad topology

[Ferjo]

Hi,

I want to calculate the shortest way between two points using pgr_dijkstra
function. When I excecute that function, it doesn't show anything. Only when
two points are just in front of each other, pgr_dijkstra shows the way it is
between them. Just in this last case, pgr_dijkstra works fine. But when the
calculation is more complex, pgr_dijkstra does nothing.

I made a lot of tries and I am sure that pgr_createTopology doesn't work as
it should. Maybe my table needs more fields to get its topology done well,
but I don´t know what.

An explanation about what fields are needed for pgr_createTopology would be
helpful too.

I attach two screenshots: how it built the table's topology and its fields
composition.

Thank you very much!

 

 




--
View this message in context: 
http://postgresql.nabble.com/pgr-createTopology-creates-bad-topology-tp5925750.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support