Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WFH8W-0007l0-1g for pgsql-sql@arkaria.postgresql.org; Mon, 17 Feb 2014 05:53:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WFH8U-00031j-MP for pgsql-sql@arkaria.postgresql.org; Mon, 17 Feb 2014 05:52:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WFH8T-00031c-D4 for pgsql-sql@postgresql.org; Mon, 17 Feb 2014 05:52:57 +0000 Received: from nm34-vm7.bullet.mail.sg3.yahoo.com ([106.10.151.246]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WFH8N-0004rE-Sr for pgsql-sql@postgresql.org; Mon, 17 Feb 2014 05:52:57 +0000 Received: from [106.10.166.126] by nm34.bullet.mail.sg3.yahoo.com with NNFMP; 17 Feb 2014 05:52:48 -0000 Received: from [106.10.150.25] by tm15.bullet.mail.sg3.yahoo.com with NNFMP; 17 Feb 2014 05:52:48 -0000 Received: from [127.0.0.1] by omp1026.mail.sg3.yahoo.com with NNFMP; 17 Feb 2014 05:52:48 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 407406.80484.bm@omp1026.mail.sg3.yahoo.com Received: (qmail 52751 invoked by uid 60001); 17 Feb 2014 05:52:48 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s1024; t=1392616368; bh=xyT+vzglQcB6el1sW1KoENTX8s2t2ifR312EsEKTsgk=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=rnyy3WHhUPBC9+nsV+4Fihq3i9P4DaLNEk1I5tMUPCQzEsTs9rrf87sGchZ1Hvf1Qr4tgvCVKsDu6ShNfhItvTp26Cn9I37ifD97Lo6W35v8BNhjJe8GGP4B5cIk1LvuQDf+iDCihlO3zipI/66qpkuNe36mznqGgtPxkYY318c= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=jW+L0a1zILIDE3M9pgH5fZjDA4HodcyARnql0tThrSTfywRnPVi0S27j5wKgkJJWZM2l8aXiPXOqcUdcmBy8zfMgtEk2qZ3kld1uQFQjaxfY295scoY1JVKxb4uYacOuEq6rMaMmyJEuPw0JbTLvGlyhzsJVx0x3t4lF7v444U8=; X-YMail-OSG: aWDVjykVM1nQ2CeiyaWnJnaFmauwilATr3GDNdoFVZKmxC_ Yv9DFiAapIjOPQVt6FF0uHB7zYHGXr0DcoUNtXzxRdlhMX3G09ZgNyqaCVXi EFjQFiVq133ZzWj4.SLvjOgLYjXoGWVZ2jOkNVljnfMvn9JwZFSr.QRFyJ_l AxxvKgtrKdx7dxp4uqTsQa1l3SpLpzl62TzqJkJFKphaUBea313891TdI3T3 BjHjlUxuiQmZ9Z1bHobRTfFzIKwsG7SDyvukrI5FKrIcYalGwgfvarAUF4JC iPGCb2SPfI2UScKC1BWizuUMt8JkVY_NRwh81SJ747D6ofO8yHm7DmzIG7V_ N8C8WcGrzEWzXOEZDBYTRjEB2KnvGs88XtjbEU3mrKnTMlD0fqphAgP6is.g .w82e83qWXikITVOxW1eD6O3y27C_u5LiLUfg0rQ3ykoDbT57U32ShXzGaTA WX02ud36jyy1pm8rRULeJBGmZ.U3CM685gQANAtLw7twZDd8Ei0wnTR0Ybr5 ddLbsdp3NswoJHQXVwYkIdrpKGwnEWN05UiJ6ByA.Q4RNpQ-- Received: from [129.60.57.61] by web193501.mail.sg3.yahoo.com via HTTP; Mon, 17 Feb 2014 13:52:48 SGT X-Rocket-MIMEInfo: 002.001, SGVsbG8gQUxMLAoKSSBuZWVkIGxpdHRsZSBoZWxwIHJlZ2FyZGluZyBEUk9QIEVYVEVOU0lPTi4KCkNhbiBpdCB3aWxsIGJlIHBvc3NpYmxlIHRvIGV4ZWN1dGUgc29tZSBTUUwgY29tbWFuZCBhdXRvbWF0aWNhbGx5IGFmdGVyIERST1AgRVhURU5TSU9OID8KCkluIG15IEVYVEVOU0lPTiwgSSBhbSBjaGFuZ2luZyBzb21lIHBnX2NhdGFsb2cgdHVwbGVzLCBJIHdhbnQgdG8gcmVzdG9yZSBpdCB3aGVuIG15IEVYVEVOU0lPTiBpcyBkcm9wcGVkLsKgCgpUaGFua3MgaW4gYWR2YW5jZSwgYW55IGhlbHAgb3Igc3UBMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 Message-ID: <1392616368.60045.YahooMailNeo@web193501.mail.sg3.yahoo.com> Date: Mon, 17 Feb 2014 13:52:48 +0800 (SGT) From: amul sul Reply-To: amul sul Subject: Trigger SQL script execution after DROP EXTENSION To: "pgsql-sql@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1439325297-1080739444-1392616368=:60045" X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org ---1439325297-1080739444-1392616368=:60045 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello ALL,=0A=0AI need little help regarding DROP EXTENSION.=0A=0ACan it wi= ll be possible to execute some SQL command automatically after DROP EXTENSI= ON ?=0A=0AIn my EXTENSION, I am changing some pg_catalog tuples, I want to = restore it when my EXTENSION is dropped.=A0=0A=0AThanks in advance, any hel= p or suggestion is appreciated.=0A=A0=0ARegards,=0A=0AAmul Sul ---1439325297-1080739444-1392616368=:60045 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hello ALL,

I need little help regar= ding DROP EXTENSION.

Can it will be possible to execute some S= QL command automatically after DROP EXTENSION ?

In my EXTENS= ION, I am changing some pg_catalog tuples, I want to restore it when my EXT= ENSION is dropped. 

Thanks in advance, any help or sug= gestion is appreciated.
 
Regard= s,
=0A
Amul Sul
---1439325297-1080739444-1392616368=:60045--