Hi Beena, How about using *TWO* extension? 1. ext_install 2. ext_uninstall Let me explain, 1. ext_uninstall will contain two command, A] SQL calling to cleanup function B] DROP EXTENSION ext_install 2. ext_install will have DROP EXTENSION IF EXISTS ext_install (cycle of install/uninstall) other wise you may not able to create ext_install again & other command. it wont sound good, but AFAICS no other option. Thoughts? Comments? Regards, Amul Sul -- View this message in context: http://postgresql.1045698.n5.nabble.com/excute-function-before-DROP-EXTENSION-tp5758279p5792350.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
