|
Hi all: 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 message: 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:
CREATE TABLE roads_europe (gid int UNIQUE, source_id int, target_id int); SELECT AddGeometryColumn('roads_europe', 'the_geom', -1, 'MULTILINESTRING', 2 ); INSERT INTO roads_europe (gid, the_geom) (SELECT gid, the_geom FROM roads_europe_tmp);
I created a new database and use different
data, I still got same error message. Thanks in advance for your help. Fay |
_______________________________________________ Cartoweb-users mailing list [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
