Thread: Uninstall in contrib/

Hi Guys,

It would be really neat if the contrib makefile could run an sql script upon
uninstall as well as removing the files.  Is that a neat idea?  Means it can
get rid off all the functions, types, etc. automatically.

Unfortunately it's a bit beyond my meagre Makefile abilities...

Chris

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> It would be really neat if the contrib makefile could run an sql script upon
> uninstall as well as removing the files.  Is that a neat idea?  Means it can
> get rid off all the functions, types, etc. automatically.

Automatically?  How will it determine which database(s) contain the
types?  What if the databases require password access?

It probably would be useful to supply an uninstall SQL script to reverse
the effects of the install script, but since we have no idea where the
install was run I think we'll have to rely on the DBA to use the script.
        regards, tom lane

> Automatically?  How will it determine which database(s) contain the
> types?  What if the databases require password access?
> 
> It probably would be useful to supply an uninstall SQL script to reverse
> the effects of the install script, but since we have no idea where the
> install was run I think we'll have to rely on the DBA to use the script.

Ah - that's probably what I meant.

Chris