Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes.

Columns:
gid | length | the_geom | source | target

Now my problem is that when I try to execute the assign_vertex_id function it is giving me the following error;

PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement ERROR: query string argument of EXECUTE is null CONTEXT: PL/pgSQL function "assign_vertex_id" line 32 at EXECUTE statement

*** Error ***

ERROR: query string argument of EXECUTE is null SQL state: 22004

Any suggestions what does this mean? Context: PL/pgSQL function "assign_vertex_id" line 32 at EXECUTE statement

share|improve this question
    
How does your query look like? – dkastl Sep 8 '12 at 0:26
    
Assign_vertex_id(‘way’, 0.00001, ‘the_geom’, ‘gid’) – Ryan Sep 8 '12 at 7:25
    
Oops, sorry my another answer's description was wrong. If you use assign_vertex_id function, use PostGIS v1.5.x because of another MultilineString issue. – sanak Sep 12 '12 at 14:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.