summaryrefslogtreecommitdiff
path: root/contrib/dblink
diff options
context:
space:
mode:
authorPeter Eisentraut2006-02-27 12:54:39 +0000
committerPeter Eisentraut2006-02-27 12:54:39 +0000
commitfe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (patch)
tree33659142c317fc19ac4db5d70e8883e47a0c7821 /contrib/dblink
parentd46fbef386b88d062bb0b00f17cbcf97f58ec821 (diff)
contrib uninstall scripts
by David Fetter
Diffstat (limited to 'contrib/dblink')
-rw-r--r--contrib/dblink/Makefile3
-rw-r--r--contrib/dblink/uninstall_dblink.sql59
2 files changed, 61 insertions, 1 deletions
diff --git a/contrib/dblink/Makefile b/contrib/dblink/Makefile
index 8fa350807b7..1c8b6587545 100644
--- a/contrib/dblink/Makefile
+++ b/contrib/dblink/Makefile
@@ -1,4 +1,4 @@
-# $PostgreSQL: pgsql/contrib/dblink/Makefile,v 1.10 2005/09/27 17:13:01 tgl Exp $
+# $PostgreSQL: pgsql/contrib/dblink/Makefile,v 1.11 2006/02/27 12:54:38 petere Exp $
MODULE_big = dblink
PG_CPPFLAGS = -I$(libpq_srcdir)
@@ -6,6 +6,7 @@ OBJS = dblink.o
SHLIB_LINK = $(libpq)
DATA_built = dblink.sql
+DATA = uninstall_dblink.sql
DOCS = README.dblink
REGRESS = dblink
diff --git a/contrib/dblink/uninstall_dblink.sql b/contrib/dblink/uninstall_dblink.sql
new file mode 100644
index 00000000000..4ef8e081708
--- /dev/null
+++ b/contrib/dblink/uninstall_dblink.sql
@@ -0,0 +1,59 @@
+DROP FUNCTION dblink_current_query ();
+
+DROP FUNCTION dblink_build_sql_update (text, int2vector, int4, _text, _text);
+
+DROP FUNCTION dblink_build_sql_delete (text, int2vector, int4, _text);
+
+DROP FUNCTION dblink_build_sql_insert (text, int2vector, int4, _text, _text);
+
+DROP FUNCTION dblink_get_pkey (text);
+
+CREATE TYPE dblink_pkey_results AS (position int4, colname text);
+
+DROP FUNCTION dblink_exec (text,bool);
+
+DROP FUNCTION dblink_exec (text);
+
+DROP FUNCTION dblink_exec (text,text,bool);
+
+DROP FUNCTION dblink_exec (text,text);
+
+DROP FUNCTION dblink (text,bool);
+
+DROP FUNCTION dblink (text);
+
+DROP FUNCTION dblink (text,text,bool);
+
+DROP FUNCTION dblink (text,text);
+
+DROP FUNCTION dblink_close (text,text,bool);
+
+DROP FUNCTION dblink_close (text,text);
+
+DROP FUNCTION dblink_close (text,bool);
+
+DROP FUNCTION dblink_close (text);
+
+DROP FUNCTION dblink_fetch (text,text,int,bool);
+
+DROP FUNCTION dblink_fetch (text,text,int);
+
+DROP FUNCTION dblink_fetch (text,int,bool);
+
+DROP FUNCTION dblink_fetch (text,int);
+
+DROP FUNCTION dblink_open (text,text,text,bool);
+
+DROP FUNCTION dblink_open (text,text,text);
+
+DROP FUNCTION dblink_open (text,text,bool);
+
+DROP FUNCTION dblink_open (text,text);
+
+DROP FUNCTION dblink_disconnect (text);
+
+DROP FUNCTION dblink_disconnect ();
+
+DROP FUNCTION dblink_connect (text, text);
+
+DROP FUNCTION dblink_connect (text);