Uninstall script for pgcrypto.
Index: pgsql/contrib/pgcrypto/Makefile
===================================================================
*** pgsql.orig/contrib/pgcrypto/Makefile
--- pgsql/contrib/pgcrypto/Makefile
*************** MODULE_big = pgcrypto
*** 35,40 ****
--- 35,41 ----
OBJS = $(SRCS:.c=.o)
DOCS = README.pgcrypto
DATA_built = pgcrypto.sql
+ DATA = uninstall_pgcrypto.sql
EXTRA_CLEAN = gen-rtab
REGRESS = init md5 sha1 hmac-md5 hmac-sha1 blowfish rijndael \
Index: pgsql/contrib/pgcrypto/uninstall_pgcrypto.sql
===================================================================
*** /dev/null
--- pgsql/contrib/pgcrypto/uninstall_pgcrypto.sql
***************
*** 0 ****
--- 1,45 ----
+
+ SET search_path = public;
+
+ DROP FUNCTION digest(text, text);
+ DROP FUNCTION digest(bytea, text);
+ DROP FUNCTION digest_exists(text);
+
+ DROP FUNCTION hmac(text, text, text);
+ DROP FUNCTION hmac(bytea, bytea, text);
+ DROP FUNCTION hmac_exists(text);
+
+ DROP FUNCTION crypt(text, text);
+ DROP FUNCTION gen_salt(text);
+ DROP FUNCTION gen_salt(text, int4);
+
+ DROP FUNCTION encrypt(bytea, bytea, text);
+ DROP FUNCTION decrypt(bytea, bytea, text);
+ DROP FUNCTION encrypt_iv(bytea, bytea, bytea, text);
+ DROP FUNCTION decrypt_iv(bytea, bytea, bytea, text);
+ DROP FUNCTION cipher_exists(text);
+
+ DROP FUNCTION pgp_sym_encrypt(text, text);
+ DROP FUNCTION pgp_sym_encrypt_bytea(bytea, text);
+ DROP FUNCTION pgp_sym_encrypt(text, text, text);
+ DROP FUNCTION pgp_sym_encrypt_bytea(bytea, text, text);
+ DROP FUNCTION pgp_sym_decrypt(bytea, text);
+ DROP FUNCTION pgp_sym_decrypt_bytea(bytea, text);
+ DROP FUNCTION pgp_sym_decrypt(bytea, text, text);
+ DROP FUNCTION pgp_sym_decrypt_bytea(bytea, text, text);
+
+ DROP FUNCTION pgp_pub_encrypt(text, bytea);
+ DROP FUNCTION pgp_pub_encrypt_bytea(bytea, bytea);
+ DROP FUNCTION pgp_pub_encrypt(text, bytea, text);
+ DROP FUNCTION pgp_pub_encrypt_bytea(bytea, bytea, text);
+ DROP FUNCTION pgp_pub_decrypt(bytea, bytea);
+ DROP FUNCTION pgp_pub_decrypt_bytea(bytea, bytea);
+ DROP FUNCTION pgp_pub_decrypt(bytea, bytea, text);
+ DROP FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text);
+ DROP FUNCTION pgp_pub_decrypt(bytea, bytea, text, text);
+ DROP FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text, text);
+
+ DROP FUNCTION pgp_key_id(bytea);
+ DROP FUNCTION armor(bytea);
+ DROP FUNCTION dearmor(text);
+
--
