Opened 12 years ago

Closed 12 years ago

#1849 closed defect (wontfix)

Error during DB migrate from Postgis 1.4 to 2.0

Reported by: davidMF Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.1
Component: postgis Version: 2.0.x
Keywords: Upgrade Cc:


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.

Change History (3)

comment:1 by pramsey, 12 years ago

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?

comment:2 by davidMF, 12 years ago

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

comment:3 by robe, 12 years ago

Resolution: wontfix
Status: newclosed

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

Note: See TracTickets for help on using tickets.