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);
+ 

--

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to