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

[Pedro Costa]

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