summaryrefslogtreecommitdiff
path: root/contrib/tablefunc
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/tablefunc
parentd46fbef386b88d062bb0b00f17cbcf97f58ec821 (diff)
contrib uninstall scripts
by David Fetter
Diffstat (limited to 'contrib/tablefunc')
-rw-r--r--contrib/tablefunc/Makefile1
-rw-r--r--contrib/tablefunc/uninstall_tablefunc.sql29
2 files changed, 30 insertions, 0 deletions
diff --git a/contrib/tablefunc/Makefile b/contrib/tablefunc/Makefile
index be18f9163e3..e2e10c0c9ef 100644
--- a/contrib/tablefunc/Makefile
+++ b/contrib/tablefunc/Makefile
@@ -1,5 +1,6 @@
MODULES = tablefunc
DATA_built = tablefunc.sql
+DATA = uninstall_tablefunc.sql
DOCS = README.tablefunc
REGRESS = tablefunc
diff --git a/contrib/tablefunc/uninstall_tablefunc.sql b/contrib/tablefunc/uninstall_tablefunc.sql
new file mode 100644
index 00000000000..e08f6837032
--- /dev/null
+++ b/contrib/tablefunc/uninstall_tablefunc.sql
@@ -0,0 +1,29 @@
+SET search_path = public;
+
+DROP FUNCTION connectby(text,text,text,text,text,int);
+
+DROP FUNCTION connectby(text,text,text,text,text,int,text);
+
+DROP FUNCTION connectby(text,text,text,text,int);
+
+DROP FUNCTION connectby(text,text,text,text,int,text);
+
+DROP FUNCTION crosstab(text,text);
+
+DROP FUNCTION crosstab(text,int);
+
+DROP FUNCTION crosstab4(text);
+
+DROP FUNCTION crosstab3(text);
+
+DROP FUNCTION crosstab2(text);
+
+DROP TYPE tablefunc_crosstab_4;
+
+DROP TYPE tablefunc_crosstab_3;
+
+DROP TYPE tablefunc_crosstab_2;
+
+DROP FUNCTION crosstab(text);
+
+DROP FUNCTION normal_rand(int4, float8, float8);