Thank you guys..
It works :-)....
I have only one more problem with pgrouting that i'm instaled from the
repository 'ppa:georepublic/pgrouting'.
When i run the function assign_vertex [1] i got an error [2].
I think might be because i have all data in another schema. I already
run populate_geometry_columns but don't work.
Anybody knows a solution?
[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
Em 14-03-2013 12:52, Pedro Costa escreveu:
Hi guys,
I have one databse with postgis 1.5 and want make a dump of them to
restore in database with postgis 2.0.
I'm tried but in new database with version 2.0 i got problems.
For example, the same query [1] in postgis 1.5 give me ~500 records
but in postgis 2.0 give 0 records.
Can someone help me with that?
Thanks
[1]
select count(*)
from streets
where the_geom && GeomFromText
('POLYGON((88386.2413216648 122184.527972102,88386.2413216648
124022.075913784,91216.2575858403 124022.075913784,91216.2575858403
122184.527972102,88386.2413216648 122184.527972102))',27492);
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
