Uninstalling adminpack

[August Zajonc <augustz(at)augustz(dot)com>]

It's always fun installing new software. Sometimes though you need to
clean it out, for testing, because it's not needed etc.

Attached is a stab at making the adminpacks somewhat easier to uninstall.

The one question I had was on the LANGUAGE INTERNAL compatibility
functions, which I'm assuming earlier versions of pgadmin used?

Feedback welcome, testing probably neede.

- August




Index: Makefile
===================================================================
--- Makefile	(revision 5029)
+++ Makefile	(working copy)
@@ -1,6 +1,7 @@
 MODULE_big = admin81
 PG_CPPFLAGS = -I$(libpq_srcdir)
 DATA_built = admin81.sql
+DATA = admin81_uninstall.sql
 DOCS = README.admin81
 OBJS = admin81.o
 
Index: README.admin81
===================================================================
--- README.admin81	(revision 5029)
+++ README.admin81	(working copy)
@@ -36,6 +36,18 @@
 
 On PostgreSQL 8.1 or above, you should use the admin81.sql script.
 
+Uninstall
+============
+
+To uninstall use the helper script admin81_uninstall.sql:
+
+psql -U postgres postgres < admin81_uninstall.sql
+
+and then run:
+
+make [USE_PGXS=1] uninstall 
+
+
 Objects implemented (superuser only)
 ====================================
 

/* ***********************************************
 * Cleanup administrative functions
 * for PostgreSQL 8.1.x
 * *********************************************** */

/* drop generic file access functions (genfile.c) */

DROP FUNCTION pg_catalog.pg_file_write(text, text, bool);

DROP FUNCTION pg_catalog.pg_file_rename(text, text, text);

DROP FUNCTION pg_catalog.pg_file_unlink(text);

DROP FUNCTION pg_catalog.pg_file_rename(text, text);

DROP FUNCTION pg_catalog.pg_logdir_ls();

/* Drop compatibility redefines */

DROP FUNCTION pg_catalog.pg_logfile_rotate();

DROP FUNCTION pg_catalog.pg_file_read(text, bigint, bigint);

DROP FUNCTION pg_catalog.pg_file_length(text);