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?