[postgis-users] Cannot execute "SELECT assign_vertex_id('graph_nw_test', 1); " multiple times

Michael Fuhr mike at fuhr.org
Fri Jun 30 13:44:20 PDT 2006


On Fri, Jun 30, 2006 at 11:56:07AM -0400, Fay Du wrote:
>    I have a graph table called graph_new_test. Open pgAdminIII Query
> form, I typed command  "SELECT assign_vertex_id('graph_nw_test', 1);",
> then clicked Execute Query button, the command was executed
> successfully. Without doing anything, I clicked on Execute Query button
> second, I got error message, it said:
> ERROR:  relation with OID 411194 does not exist
> CONTEXT:  SQL statement "SELECT  id, the_geom FROM vertices_tmp WHERE
> distance(the_geom,  $1 ) <  $2 "
> PL/pgSQL function "point_to_id" line 7 at select into variables
> PL/pgSQL function "assign_vertex_id" line 22 at assignment

Is vertices_tmp a temporary table?  If so then see the PostgreSQL
FAQ for the error's cause and how to avoid it:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

-- 
Michael Fuhr



More information about the postgis-users mailing list