Thread: [patch 5/9] uninstall script

[patch 5/9] uninstall script

From
Marko Kreen
Date:
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);
+

--