[postgis-users] dump a database with postgis 1.5 to a database with postgis 2.0

[Pedro Costa]

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);