[pgrouting-users] Problem with dijkstra_sp:

[Maria Battarra]

Hi All,

I would appreciate a lot your help if you could suggest how to fix this:
"dijkstra_sp" function seems not to work :-s. 

I excuse in advance: my knowledge of db and gis systems is very little and
you will have to provide a "pgrouting for dummies" explanation J

 

I am working with win32, postgresql 8.4, pgadmin 1.10.5, postgis 1.5,
pgrouting 1.03. 

 

I processed my  shp file in  Openjump  first (I made the edge file planar
and calculated the length of the edges) and then imported it in postgresql
by using this plugin for pgadmin:
http://www.roxor.it/guide/13-guide-gis/13-guida-importare-shape-postgres-pos
tgis.html.

 

I have imported all the pgrouting functions by following these steps:
http://hi.baidu.com/%C5%A3%B5%C3%CC%EC%CF%C2/blog/item/beabb7b4512c35c037d3c
a03.html (step 2).

I have currently all the postgis and pgrouting functions loaded, a table
with the "the_geom", "gid", "source", "target", "length" fields, as
described in the link above and a table that will contain the results of
dijkstra (steps 5, 6,7,8). 

I get stuck when I call the  "dijkstra_sp" function (step 8).. the error msg
is:

 

ERROR:  source contains a null value

CONTEXT:  PL/pgSQL function "dijkstra_sp" line 12 at cycle FOR in an
instruction EXECUTE

 

Any idea about what went wrong?

Thanks a lot!

Maria

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110427/2a793b20/attachment.html