Uninstalling old pgsphere to install new pgsphere

[esabol]

I recently upgraded our PostgreSQL database from 9.2 to 10.1, and I experienced various issues as a result of having installed the old (pre-extension) version of pgsphere. CREATE EXTENSION pg_sphere; failed because the datatypes and functions already existed. The only solution I could find was to DROP all the pgsphere datatypes/functions/etc. with CASCADE first, then pg_upgrade, and then CREATE EXTENSION pg_sphere; would work.

I don't know if that's an issue for anyone else. If it is, maybe this SQL file will save someone some time:

pgsphere_uninstall.txt

[ghost]

Well, it is certainly an issue for quite a few people. Thanks to help from @akorotkov, I have working scripts for an adapted version of PgSphere that runs behind http://dc.g-vo.org -- they allow a proper upgrade via
CREATE EXTENSION pg_sphere FROM unpackaged;
In this way, all data types, tables, and indexes will be preserved. Only a couple of somehow buggy operator definitions (they have been fixed a long time ago by @pdowler) will be dropped with CASCADE (ALTER OPERATOR lacks the ability to change certain things) and recreated via FROM unpackaged.

Expect a respective commit here sometime soon™.