[postgis-devel] New uninstall_postgis.sql script

Paul Ramsey pramsey at cleverelephant.ca
Sat Jun 6 07:29:26 PDT 2009


I don't think you can pull the geometry types out from underneath the
tables, can you? And I'm not sure about removing functions that are
referred to in constraints, like st_srid() and st_geometrytype().

P.

On Sat, Jun 6, 2009 at 7:18 AM, Mark
Cave-Ayland<mark.cave-ayland at siriusit.co.uk> wrote:
> Hi all,
>
> I've just committed a new generated uninstall_postgis.sql script to 1.4
> which gives the complete SQL script required to remove all of the PostGIS
> functions/types/operators from a database. So please if you do add/change
> any functions types, please verify that you also update the install SQL
> script too.
>
> At the moment, the script simply uses DROP TYPE ... CASCADE on the PostGIS
> types which removes them completely from the database; however it struck me
> that this could be a way of unifying our installation/removal/upgrade
> procedures since an upgrade process involves removing all of the old
> definitions and adding the new ones. Obviously this would only work with 1.4
> onwards, but easier upgrades would put us in a great position going
> forwards. Thoughts?
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> http://www.siriusit.co.uk
> t: +44 870 608 0063
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



More information about the postgis-devel mailing list