|
It solved by log off the account, do
something else (include sending asking for help email in different account), then
log in again. Nothing else changed. Connect the same database and use same
table, copy/past the same command: SELECT assign_vertex_id('roads_europe', 1); It works. But before I log off, I spent
over an hour and could not make it work. Fay -----Original Message----- 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: 1. shp2pgsql
C:\temp\roadl.shp roads_europe_tmp > C:\temp\roadl.sql 2. psql
–d dcmms –f
C:\temp\roadl.sql 3. 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); 4. SELECT
assign_vertex_id(‘roads_europe’, 1); 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
