pgrouting data import off

[wildintellect]

pgrouting seems to build ok but the data import doesn't work out, for some reason the make install isn't putting the pgrouting .sql files into /usr/share/postlbs. Log is attached to ticket.

[wildintellect]

pgrouting build log live 3.0alpha

[wildintellect]

More info on the build error, should forward to pgrouting contact:

[ 25%] Building C object extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c: In function ‘fetch_vertices_columns’:
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: ‘INT4OID’ undeclared (first use in this function)
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: (Each undeclared identifier is reported only once
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:137: error: for each function it appears in.)
/tmp/build_pgrouting/pgrouting/extra/driving_distance/src/alpha.c:138: error: ‘FLOAT8OID’ undeclared (first use in this function)
make[2]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/alpha.o] Error 1
make[1]: *** [extra/driving_distance/src/CMakeFiles/routing_dd.dir/all] Error 2
make: *** [all] Error 2

[hamish]

these errors in the 3.0rc1a build log:

...
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
COMMIT
ANALYZE
/usr/share/postlbs/routing_core.sql: No such file or directory
/usr/share/postlbs/routing_core_wrappers.sql: No such file or directory
/usr/share/postlbs/routing_topology.sql: No such file or directory
/usr/share/postlbs/routing_tsp.sql: No such file or directory
/usr/share/postlbs/routing_tsp_wrappers.sql: No such file or directory
/usr/share/postlbs/routing_dd.sql: No such file or directory
/usr/share/postlbs/routing_dd_wrappers.sql: No such file or directory
DROP TABLE
psql:schema.sql:76: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "geometry_columns_pk" for table "geometry_columns"
ERROR:  function dijkstra_sp_delta(unknown, integer, integer, numeric) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM dijkstra_sp_de...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
ERROR:  function astar_sp_delta(unknown, integer, integer, numeric) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM astar_sp_delta...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
ERROR:  function shootingstar_sp(unknown, integer, integer, numeric, unknown, boolean, boolean) does not exist
LINE 1: SELECT gid, AsText(the_geom) AS the_geom FROM shootingstar_s...
                                                      ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Finished: ./install_pgrouting.sh

(any way to make those INSERTs go quietly?)

also, install_pgrouting.sh script does not clean up the -dev packages it pulls in, and that's hundreds of megabytes.

Hamish

[wildintellect]

Was a compile issue, package was updated and issue resolved.