> 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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to