demo (#22) - function assign_vertex_id does not exist (#240) - Message List
Dear Forum,
I try to use pgRouting 1.03 on a Debian-machine.
I didn`t get any errors while doint the installation: http://pgrouting.postlbs.org/wiki/1.x/InstallationManual
but in the database the function assign_vertex_id does not exist (while the other routing functions seem to be in).
What might create that problem?
Thank you very much, Kai
-
Message #843
In 1.0.3 one must load also routing_topology.sql, then the functions are in the database. But now I get
SQL error:
server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.
In der Anweisung: SELECT assign_vertex_id('routingroads', 0.001, 'the_geom_900913', 'gid')
??
Kai-Behncke04/04/09 16:58:04 (20 months ago) -
Message #844
Hello Kai,
Welcome back to the forum. If you use Linux anyhow, I would recommend you to checkout the trunk version. Because there were no big changes recently but probably a few bug fixes, trunk version might be the better choice.
daniel04/04/09 17:14:49 (20 months ago)-
Message #845
Hi Daniel,
ok, I will try that. I think the problem I have now is a problem of PostgreSQL. It`s written "Note: "endpoint()" function fails for some versions of PostgreSQL (ie. 8.2.5, 8.1.9). A workaround for that problem is using the "PointN()" function instead:"
I wonder how to get that in
" FOR _r IN EXECUTE 'SELECT '
quote_ident(gid_cname) ' AS id,' ' StartPoint?(' quote_ident(geo_cname) ') AS source,' ' EndPoint?(' quote_ident(geo_cname) ') as target' ' FROM ' quote_ident(geom_table) " (so far I had no luck). Best regards, Kai
Kai-Behncke04/04/09 17:35:05 (20 months ago)-
Message #846
Do you mean this? http://pgrouting.postlbs.org/wiki/Workshop-PrepareAStar
There is a work-around how to get the same if you can't use this function.
daniel04/04/09 17:40:33 (20 months ago)-
Message #847
Yes, that workaround works well, but I think I need to get that workaround also in the function "assign_vertex_id" (That`s the point where I stuck in the moment).
But anyway, I think it`s really time to update my old 8.1.15-Postgresql-Version today :-) (that might solve the problem).
Best regards, Kai
Kai-Behncke04/04/09 17:50:17 (20 months ago)
-
Powered by Trac 0.11.5rc1
By Edgewall Software.pgRouting is a project of PostLBS
http://www.postlbs.org/ -
-