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,
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?
[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
I don't have any function called 'st_find_srid'...
May be you changed another function?
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@sapo.pt>
To: pgRouting users mailing list <pgrouting-users@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?
[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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/pgrouting-users
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@sapo.pt>
To: pgRouting users mailing list <pgrouting-users@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?
[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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/pgrouting-users