[Cartoweb-users] Errors when using assign_vertex_id function
fay.du at versaterm.com
Wed Jan 11 13:27:02 EST 2006
Thanks everyone, especially Alexandre, helping me to install PostGIS and
pgdijkstra on windows. Now I have a new problem need your help.
I download the demo data and following user manual (page 28) to create a
table roads_europe and populate the data.
When I run following command, I got an error.
Command: SELECT assign_vertex_id('roads_europe', 1);
ERROR: relation with OID 17715 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
What is OID 17715? Why I got this error? What I did wrong? Following is
step by step of what I did:
1. shp2pgsql C:\temp\roadl.shp roads_europe_tmp > C:\temp\roadl.sql
2. psql -d dcmms -f C:\temp\roadl.sql
CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id
SELECT AddGeometryColumn('roads_europe', 'the_geom', -1,
'MULTILINESTRING', 2 );
INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM
4. SELECT assign_vertex_id('roads_europe', 1);
I created a new database and use different data, I still got same error
Thanks in advance for your help.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Cartoweb-users