Forum #23 - Topic #28 - Message List
i imported a map into the database and added columns for the source_id and the target_id when i try to run assign_vertex_id i get this: PL/pgSQL function "assign_vertex_id" line 17 at SQL statement ERROR: cannot EXECUTE a null querystring CONTEXT: PL/pgSQL function "assign_vertex_id" line 41 at execute statement
i changed the srid in the function to match the srid of the map and it still gives me this error
Im a student trying to use dijkstra to find the shortest path and display it on a map however
Im running pgRouting-1.0.0a on Ubuntu feisty with postgres 8.1 and postgresql-postgis 1.1.6
-
Message #96
Well, it is quite hard to say what happened...
Can you send me a small piece of your table and an example of the assign_vertex_id invocation?
I've sent you my email already, 'cause I don't want to post it here :)
anton07/13/07 10:02:30 -
Message #101
can you please resend theyour email address mine was incorrect fixed it now thanx
g3rsh0m07/13/07 22:19:55 -
Message #107
Can you try to get a newer version of routing_postgis.sql file from SVN? It has another version of assign_vertex_id function with two more parameters - geometry column name and gid column name.
Can you try it with your data? It should work.
anton07/18/07 13:03:05 -
Message #129
the project is over but the shortest path didnt work too well
re trying the new routing_postgis.sql file, i tried that and it still didnt work a group member found out that there were some columns with null values that prevented the assign_vertex_id from working
It seems that the map that we had was buggy and hence caused this and other problems along the way
Thanx for the help and suggestion though
Will continue exploring GIS and pgrouting Keep up the good work
g3rsh0m08/08/07 17:29:08
