[pgrouting-users] postgis 2.0 error find_srid()

[Pedro Costa]

I founded the problem...
In the function i'm changed the schema 'public' to my ('data')...

Now i gets another error:


'ERROR:  query string argument of EXECUTE is null'






Em 15-03-2013 12:01, Ian Tangert escreveu:
> hi,
>
> 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,
>
> Ian
>
>
>
> -------- Original message --------
> Subject: [pgrouting-users] postgis 2.0 error find_srid()
> From: Pedro Costa <pedrocostaarma at sapo.pt>
> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> CC:
>
>
> Hi guys,
>
> I'm installed the pgrouting with postgres 9.1.8 and postgis 2 and i have
> all my data in a distint schema (not 'public')...
> When i run the query to create topology [1] i get an error [2].
>
> I'm already try to run select 'populate_geometry_columns()' and the
> table is corectly referenced in geometry_columns.
>
> Can anybody help me with that or a different function of postgis to
> create topology?
>
> thanks
>
> [1]
> SELECT assign_vertex_id('arcos', .001, 'the_geom', 'id');
>
> [2]
> NOTICE:  CREATE TABLE will create implicit sequence
> "vertices_tmp_id_seq" for serial column "vertices_tmp.id"
> CONTEXT:  SQL statement "CREATE TABLE vertices_tmp (id serial)"
> PL/pgSQL function "assign_vertex_id" line 15 at EXECUTE statement
> ERROR:  find_srid() - couldnt find the corresponding SRID - is the
> geometry registered in the GEOMETRY_COLUMNS table?  Is there an
> uppercase/lowercase missmatch?
> CONTEXT:  PL/pgSQL function "assign_vertex_id" line 21 at assignment
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20130315/858bd6ca/attachment-0001.html>