Forwarded to the pgrouting list. Please ask questions like this on the list to everyone benefits from the Q and A.

postgis_topology does not not build a topology that is in the form that pgrouting can use. You would need to extract a new edge table based on the postgis_topology results, than run the pgr_createtopology() on that new table.

Alternatively, you might try to run pgr_nodenetwork() on you orginial table and then run pgr_greatetopology() on its output table.

-Steve

-------- Forwarded Message --------

Subject: PROBLEM WITH SHORTEST PATH IN POSTGRESQL 9.2

Date: Fri, 30 Oct 2015 10:15:52 -0500

From: Juan Enrique Rojas Sanchez <j.enrique4791@gmail.com>

To: woodbri@swoodbridge.com

Hello

I use 9.2 PostgreSQL version, have a problem ... I created topology in

two ways:

- With the extension pgRouting

- With the extension postgis_topology

In the first case we can calculate the shortest path through algorithms

such as pgr_dijkstra (), the problem is that the topology not generated

correctly, using pgr_createTopology (exist missing nodes).

Whereas in the second case, it create the topology correctly (with all

nodes that should go), but instead there is no function to calculate routes.

I need an algorithm that returns me the shortest path and geometries

Help me, please

Thank you

--

*Atentamente

Juan Enrique Rojas Sánchez

Escuela de Ingeniería de Sistemas y Computación

UNIVERSIDAD CATÓLICA SANTO TORIBIO DE MOGROVEJO (PERÚ)

**Escuela de Ingeniería en Computación

UNIVERSIDAD NACIONAL AUTÓNOMA DE MÉXICO (MÉXICO)*