summaryrefslogtreecommitdiff
path: root/contrib/userlock
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/userlock')
-rw-r--r--contrib/userlock/Makefile3
-rw-r--r--contrib/userlock/uninstall_user_locks.sql23
2 files changed, 25 insertions, 1 deletions
diff --git a/contrib/userlock/Makefile b/contrib/userlock/Makefile
index f2eef6604f..48993d9b93 100644
--- a/contrib/userlock/Makefile
+++ b/contrib/userlock/Makefile
@@ -1,7 +1,8 @@
-# $PostgreSQL: pgsql/contrib/userlock/Makefile,v 1.19 2005/09/27 17:13:13 tgl Exp $
+# $PostgreSQL: pgsql/contrib/userlock/Makefile,v 1.20 2006/02/27 12:54:39 petere Exp $
MODULES = user_locks
DATA_built = user_locks.sql
+DATA = uninstall_user_locks.sql
DOCS = README.user_locks
ifdef USE_PGXS
diff --git a/contrib/userlock/uninstall_user_locks.sql b/contrib/userlock/uninstall_user_locks.sql
new file mode 100644
index 0000000000..178b56e3d0
--- /dev/null
+++ b/contrib/userlock/uninstall_user_locks.sql
@@ -0,0 +1,23 @@
+SET search_path = public;
+
+DROP FUNCTION user_unlock_all();
+
+DROP FUNCTION user_write_unlock_oid(int4);
+
+DROP FUNCTION user_write_lock_oid(int4);
+
+DROP FUNCTION user_write_unlock_oid(oid);
+
+DROP FUNCTION user_write_lock_oid(oid);
+
+DROP FUNCTION user_write_unlock(int4,oid);
+
+DROP FUNCTION user_write_lock(int4,oid);
+
+DROP FUNCTION user_write_unlock(int4,int4);
+
+DROP FUNCTION user_write_lock(int4,int4);
+
+DROP FUNCTION user_unlock(int4,int4,int4);
+
+DROP FUNCTION user_lock(int4,int4,int4);