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



Mon, 19 Aug 2002 23:20:35 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Uninstall in contrib/
"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

Mon, 19 Aug 2002 11:29:41 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Uninstall in contrib/ 
> 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


Mon, 19 Aug 2002 23:51:48 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: Uninstall in contrib/ 