Error during DB migrate from Postgis 1.4 to 2.0

[davidMF]

Hello. After my post on postgis-users-bounces@…, Regina advices me to post a ticket here.

My problem is that I'm trying to import data from PostGIS 1.4 (Postgres 8.3) to PostGIS 2.0 (Postgres 9.1).

I'd installed PostGIS with extension and created database with it. As I have a very old version of database, I ran legacy.sql During Hard Upgrade from dump (created with -Fc option), I got only one error during create table statement because it uses box3d_extent.

ERROR: type < box3d_extent > does not exists

I think it's an old type of data ? How to resolve it ? Is it a miss in legacy.sql ?

Thanks for all. David.

[pramsey]

We never anticipated people using box3d_extent as a column type (it was a shim return type for st_extent). In your old database, convert it to a polygon or a box3d first, and then do the upgrade from there?

[davidMF]

OK, Paul well received. I going to give this information to developpers. Thanks for all.

[robe]

Paul, strk — we can close this as a won't fix right? Feel free to open if you feel the need to do something.