<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></head><body>hi,<div><br></div><div>does it work if you change the find_srid() function to st_find_srid() in the assign_vertex_id function()? I had to add st_ to some of the functions inside the pgrouting functions once, but I'm sorry I can't remember now exactly how I built that platform,but it was postgis 2.0,</div><div><br></div><div>Ian</div><br><br><br>-------- Original message --------<br>Subject: [pgrouting-users] postgis 2.0 error find_srid() <br>From: Pedro Costa <pedrocostaarma@sapo.pt> <br>To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org> <br>CC: <br><br><br><div style="word-break:break-all;">Hi guys,<br><br>I'm installed the pgrouting with postgres 9.1.8 and postgis 2 and i have <br>all my data in a distint schema (not 'public')...<br>When i run the query to create topology [1] i get an error [2].<br><br>I'm already try to run select 'populate_geometry_columns()' and the <br>table is corectly referenced in geometry_columns.<br><br>Can anybody help me with that or a different function of postgis to <br>create topology?<br><br>thanks<br><br>[1]<br>SELECT assign_vertex_id('arcos', .001, 'the_geom', 'id');<br><br>[2]<br>NOTICE: CREATE TABLE will create implicit sequence <br>"vertices_tmp_id_seq" for serial column "vertices_tmp.id"<br>CONTEXT: SQL statement "CREATE TABLE vertices_tmp (id serial)"<br>PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement<br>ERROR: find_srid() - couldnt find the corresponding SRID - is the <br>geometry registered in the GEOMETRY_COLUMNS table? Is there an <br>uppercase/lowercase missmatch?<br>CONTEXT: PL/pgSQL function "assign_vertex_id" line 21 at assignment<br>_______________________________________________<br>Pgrouting-users mailing list<br>Pgrouting-users@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/pgrouting-users<br></div></body>