data (#23) - assign_vertex_id Problem (#210) - Message List

assign_vertex_id Problem

Hi, I'm trying to run this function but is arising the following error:

NOTICE: CREATE TABLE will create implicit sequence "vertices_tmp_id_seq" for serial column "vertices_tmp.id" CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)" PL/pgSQL function "assign_vertex_id" line 14 at execute statement ERROR: relation with OID 24029 does not exist CONTEXT: SQL statement "SELECT Distance(the_geom,GeometryFromText?( AsText?( $1 ), $2 )) AS d, id, the_geom FROM vertices_tmp WHERE the_geom && Expand(GeometryFromText?(AsText?( $1 ), $2 ), $3 ) AND Distance(the_geom, GeometryFromText?(AsText?( $1 ), $2 )) < $3 ORDER BY d LIMIT 1" PL/pgSQL function "point_to_id" line 12 at select into variables PL/pgSQL function "assign_vertex_id" line 29 at assignment

Do you have any ideas why this happen¿?

Thanks in advanced,

Rafael