Re: excute function before DROP EXTENSION - Mailing list pgsql-general

From amulsul
Subject Re: excute function before DROP EXTENSION
Date
Msg-id 1392625776713-5792350.post@n5.nabble.com
Whole thread Raw
In response to excute function before DROP EXTENSION  (Beena Emerson <memissemerson@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Is PostgreSQL 9.3 using indexes for pipelined top-N window function queries?
Next
From: Andres Freund
Date:
Subject: Re: Toast and slice of toast