[pgrouting-dev] SQL uninstall scripts

[Daniel Kastl]

Some time ago Philipp proposed to add uninstall scripts for pgRouting
functions and he submit a patch:
https://github.com/pgRouting/pgrouting/pull/40

This is for sure convenient, if you want to clean your database from
pgRouting functions, though it also comes with some drawbacks:

   - If a new function is added, it also needs to be added to uninstall. I
   can easily predict, that someone will forget this some time ;-)
   - If pgRouting is re-installed it already replaces functions if they
   already exist
   - If a function has been dropped, it will probably not be part of the
   un-install script, so old functions will remain.

I thought it would be nice to have some script instead to find all functions
that were added by pgRouting and then drop them.

So first step would be to make pgRouting functions easier to identify. Steve
recently wrote a function that started with "PGR_[function name]".
I think this would be a useful convention to introduce some kind of
pgRouting "namespace" similar to "ST_" for PostGIS:
https://github.com/pgRouting/pgrouting/issues/41

Better ideas? Any thoughts? Ever missed an un-installer? Shall we apply the
patch?

Daniel




-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20110801/96e872b4/attachment.html