dijkstra (#16) - Error function "assign_vertex_id" (#280) - Message List

Error function "assign_vertex_id"

Enter your message here...

Hi, everybody!

I am working the project for my graduation. When i prepare data for dijkstra algorithm , i run function "assign_vertex_id" for data table "duong_pho_line"

"SELECT assign_vertex_id('duong_pho_line', 0.001, 'the_geom', 'gid'); UPDATE duong_pho_line SET length = length(the_geom);"

But having announce :

"ERROR: cannot EXECUTE a null querystring SQL state: 22004 Context: PL/pgSQL function "assign_vertex_id" line 65 at EXECUTE statement"

My table data is : CREATE TABLE duong_pho_line (

gid serial NOT NULL, id character varying(250), "type" character varying(250), the_geom geometry, )

I dont know what is the reason. My time is not much!

Please help me for fixed problem! Thanks! All information contact to Email : tuongvan10121987@…

tuongvan10121987
07/12/09 14:23:10 (17 months ago)
Tree View Flat View (newer first) Flat View (older first)
  • Message #983

    We discussed this situation few times here already, if you search through the forum, you will for sure find those topics.

    In few words - check geometry_column entry for your 'duong_pho_line' table, check your data projection units (0.001 might be to small value for meters or miles).

    anton
    07/13/09 10:18:00 (17 months ago)
    • Message #987

      Enter your message here... After i assign label for source and target, i check value of my street table. But having a problem : Some source label and target label is the same. Please tell me what's wrong happened to it! Qsoks!

      tuongvan10121987
      07/21/09 23:56:52 (16 months ago)
      • Message #988

        After i assign label for source and target, i check value of my street table. But having a problem : Some source label and target label is the same. Please tell me what's wrong happened to it! Qsoks!

        tuongvan10121987
        07/21/09 23:57:50 (16 months ago)
Tree View Flat View (newer first) Flat View (older first)