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:33:03
Message-ID: 1476379983392-5925750.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/n5925750/forum.jpg>

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

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

Browse pgadmin-support by date

  From Date Subject
Next Message Ferjo 2016-10-13 17:35:22 pgr_createTopology creates bad topology
Previous Message bramcote.road 2016-10-13 10:42:15 server status in pgadmin ERROR: path must be in or below the current directory CONTEXT: SQL function pg_file_length statement 1