> 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