Hi all and thanks in advance.
I have Postgis 2.0.1 and PgRouting latest version. I'm using osm2pgrouting to import OpenStreetMap data everything goes ok the trouble is that I always get source and target columns without data and when i run
SELECT assign_vertex_id('ways', 0.00001, 'the_geom', 'gid'); by hand on PGSQL I get the following error:
ERROR: syntax error at or near "vertices_tmp" LINE 1: SELECT ST_addGeometryColumn(''vertices_tmp'', ''the_geom'', ... ^
*** Error ***
ERROR: syntax error at or near "vertices_tmp" SQL state: 42601 Character: 31
After hours of reading on the net I've realized that the function assign_vertex_id() had to change somehow because it references other functions like StartPoint that it's called ST_StartPoint and i've changed that but i still get errors.
Where can I get the .sql file with the proper SQL to make the upgrade and postgis/pgrouting can work together?
Best regards from Portugal, Tiago