pgRouting

Forum #23 - Topic #89 - Message List

Prepare routing table for dijkstra

Dear forum, as it stands in the tutorium (http://pgrouting.postlbs.org/wiki/Workshop-PrepareDikstra)

I try to execute the command "SELECT assign_vertex_id('victoria', 0.001, 'the_geom', 'gid');"

But I always get error messages like that:

"FEHLER: cannot EXECUTE a null querystring CONTEXT: PL/pgSQL function "assign_vertex_id" line 26 at execute statement"

What could that mean?

In my table "victoria" I have the columns gid,id,the_geom,source,target and length.

Thank you once again, Kai

Kai-Behncke
12/27/07 06:41:43
Tree View Flat View (newer first) Flat View (older first)
  • Message #339

    Well that`s strange. I dropped the database and created it again (in my opinion with the same steps as before), but now it worked!! Maybe there where some NULL-entries before where they shouldn`t be. Anyway, the topology was created finely now.

    Kai-Behncke
    12/27/07 07:16:18
    • Message #344

      hello, its possible you executed the correct sql files when you did it again. before i executed the sql files in contrib folder (windows distribution) and got the same error. but after i try the one from svn, it is ok now.

      jontan6
      12/29/07 23:40:58
Tree View Flat View (newer first) Flat View (older first)