[Cartoweb-users] Cartoweb-users] Errors when using assign_vertex_id function - Solved by log off/log in

[Fay Du]

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-----
From: cartoweb-users-bounces at lists.maptools.org
[mailto:cartoweb-users-bounces at lists.maptools.org] On Behalf Of Fay Du
Sent: Wednesday, January 11, 2006 1:27 PM
To: cartoweb-users at lists.maptools.org
Subject: [Cartoweb-users] Errors when using assign_vertex_id function
 
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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20060111/ad24d9b6/attachment-0001.html