Following the post:pgRouting 2.0 for Windows quick guide, cuz I have some problem with DB manager(here is the problem I posted:DB manager in QGIS 2.0), I skip DB manager and save the test shapefile, using SPIT load the shapefile into PostgreSQL.
Then I type this SQL in pgAdmin:
alter table network.publictransport add column source integer;
alter table network.publictransport add column target integer;
select pgr_createTopology('network.publictransport', 0.0001, 'the_geom', 'gid');
and go check the table below:
Then I type in this SQL as in Anita's post:
SELECT seq, id1 AS node, id2 AS edge, cost, geom
FROM pgr_dijkstra(
'SELECT id, source, target, st_length(geom) as cost FROM network.publictransport',
1, 3000, false, false
) as di
JOIN network.publictransport pt
ON di.id2 = pt.id ;
but the message below shows:
I am new to SQL, and I don't know how to modify the SQL to get the same result as in Anita's post. Please give some advice to solve this problem.
SET lc_messages TO 'en_US.UTF-8';before running the query. – Jakub Kania Dec 3 '13 at 13:39