pgr_createTopology creates bad topology

From: Ferjo <ferjopero(at)hotmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgr_createTopology creates bad topology
Date: 2016-10-13 17:35:22
Message-ID: 1476380122621-5925751.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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!

<http://postgresql.nabble.com/file/n5925751/forum.jpg>

<http://postgresql.nabble.com/file/n5925751/forum_2.jpg>

--
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.

Browse pgadmin-support by date

  From Date Subject
Next Message Alejandra Pazos Freire 2016-10-13 18:08:52 pgadmin4 on windows 10 64 bits
Previous Message Ferjo 2016-10-13 17:33:03 pgr_createTopology creates bad topology