On Wed, Apr 25, 2012 at 09:23:50AM +0200, Felix Obermaier wrote: > Hello list, > > I'm having problems with my spatial tables after I "soft" updated from > postgis 1.5.3 to postgis 2.0. > Every query I execute that involves a geometry column throws > Invalid geometry type: <some large negative number>. > > Do you have any idea why this is happening,
Yes, the internal representation of geometries changed between 1.5.3 and 2.0 so "soft" upgrade isn't an option. How did you "soft" upgrade ? Did you use the postgis_upgrade_xxy scripts ? I tought we safe-guarded from such cross-major-version use within those scripts. > is there a way to fix it? Do you have a dump (in postgresql custom format) of your database ? In that case you can use an hard-upgrade procedure (proper, as described in the manual). Otherwise you can try loading the posgis.sql which comes with 1.5 and cross your fingers (maybe removing the BEGIN/END lines wrapping it all within a transaction). But whatever you do focus on backups first. --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.0 ! | / 2.0 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
