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);