[postgis-users] Problems after update to PostGis 2.0

[Felix Obermaier]

> Did you try re-installing postgis 1.5.x ?
Yes, I did, but it complained that this or that function could not be dropped/replaced because objects were depending on it.
I finally tweaked the uninstall_postgis.sql script to DROP CASCADE but then all geometry columns were gone :(.
It is not really dramatic, the geometry columns can be restored from shapefiles. I admit I don't know too much about postgresql, but maybe it is possible not to drop the geometry columns when uninstalling postgis and just leave plain binary data.

> It's in the README file, under the section UPGRADING:
> 
> << PostGIS provides a SOFT UPGRADE procedure for minor or bugfix
> releases, and an HARD UPGRADE procedure for major releases. >>
I must admit I didn't read the README but stuck with the documentation:
http://postgis.refractions.net/documentation/manual-2.0/postgis_installation.html#upgrading
Maybe it is worth a notice that soft upgrade from 1.5 or prior is bound to fail.

> > - Re ran postgis_upgrade_20_minor.sql, which this time succeeded.
> Ouch. This shouldn't have happened.
> Could you please file a ticket for this ?
I will

Thanks

Felix Obermaier