<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I founded the problem...<br>
In the function i'm changed the schema 'public' to my ('data')...<br>
<br>
Now i gets another error:<br>
<br>
<br>
'ERROR: query string argument of EXECUTE is null'<br>
<br>
<br>
<br>
<br>
<br>
<br>
Em 15-03-2013 12:01, Ian Tangert escreveu:<br>
</div>
<blockquote
cite="mid:w7a5jpl7f2o0gxl8swkuggxb.1363348374475@email.android.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
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 <a class="moz-txt-link-rfc2396E" href="mailto:pedrocostaarma@sapo.pt"><pedrocostaarma@sapo.pt></a> <br>
To: pgRouting users mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:pgrouting-users@lists.osgeo.org"><pgrouting-users@lists.osgeo.org></a> <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>
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Pgrouting-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
</blockquote>
<br>
</body>
</html>