Ticket #206 (new bug report)

Opened 6 months ago

Last modified 6 months ago

assign_vertex_id()

Reported by: alibehi5 Owned by: somebody
Priority: critical Milestone:
Component: Dijkstra Version:
Keywords: Cc:

Description

hi friends my english language is poor.i want to use assign_vertex_id() with SCHEMA name. for example i need use: select assign_vertex_id('baharestan.roads', 0.001, 'the_geom', 'gid'); but it has this 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 21 at EXECUTE statement ERROR: relation "baharestan.roads" does not exist CONTEXT: SQL statement "SELECT count(*) as countids FROM "baharestan.roads"" PL/pgSQL function "assign_vertex_id" line 28 at FOR over EXECUTE statement

********** Error **********

thanks a lot

Change History

Changed 6 months ago by zstauber

I have the same problem. "assign_vertex_id" works if I run it on a table of roads (made from Tiger 2009 shapefiles) that was created in the public schema, but if I create it in any other schema, I get that error he listed, whether I qualify the table name with the schema prefix or not.

Note: See TracTickets for help on using tickets.