agora inbox for pgsql-sql@postgresql.orghelp / color / mirror / Atom feed
Trigger SQL script execution after DROP EXTENSION 2+ messages / 2 participants [nested] [flat]
* Trigger SQL script execution after DROP EXTENSION @ 2014-02-17 05:52 amul sul <sul_amul@yahoo.co.in> 0 siblings, 1 reply; 2+ messages in thread From: amul sul @ 2014-02-17 05:52 UTC (permalink / raw) To: pgsql-sql Hello ALL, I need little help regarding DROP EXTENSION. Can it will be possible to execute some SQL command automatically after DROP EXTENSION ? In my EXTENSION, I am changing some pg_catalog tuples, I want to restore it when my EXTENSION is dropped. Thanks in advance, any help or suggestion is appreciated. Regards, Amul Sul ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Trigger SQL script execution after DROP EXTENSION @ 2014-02-17 14:26 Adrian Klaver <adrian.klaver@gmail.com> parent: amul sul <sul_amul@yahoo.co.in> 0 siblings, 0 replies; 2+ messages in thread From: Adrian Klaver @ 2014-02-17 14:26 UTC (permalink / raw) To: amul sul <sul_amul@yahoo.co.in>; pgsql-sql On 02/16/2014 09:52 PM, amul sul wrote: > Hello ALL, > > I need little help regarding DROP EXTENSION. > > Can it will be possible to execute some SQL command automatically after > DROP EXTENSION ? > > In my EXTENSION, I am changing some pg_catalog tuples, I want to restore > it when my EXTENSION is dropped. > > Thanks in advance, any help or suggestion is appreciated. Not sure what version you are on, but in 9.3+ there are EVENT TRIGGERS: http://www.postgresql.org/docs/9.3/interactive/event-triggers.html > Regards, > > Amul Sul -- Adrian Klaver adrian.klaver@gmail.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-02-17 14:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-02-17 05:52 Trigger SQL script execution after DROP EXTENSION amul sul <sul_amul@yahoo.co.in> 2014-02-17 14:26 ` Adrian Klaver <adrian.klaver@gmail.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox