[postgis-devel] New uninstall_postgis.sql script

[Obe, Regina]

Wouldn't that drop table as well?  Like all the geometry tables people use that have geometry type?


-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net on behalf of Mark Cave-Ayland
Sent: Sat 6/6/2009 10:18 AM
To: PostGIS Development Discussion
Subject: [postgis-devel] New uninstall_postgis.sql script
 
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



-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20090606/0de9e264/attachment.html>