Date: Tue, 21 Jun 2016 14:13:01 -0400
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: mschwan@opentext.com, pgsql-docs@postgresql.org
Subject: Re: DROP EXTENSION
Message-ID: <20160621181301.GA91352@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20160621165725.GA89052@alvherre.pgsql>
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

Alvaro Herrera wrote:
> Michael Paquier wrote:
> > On Tue, Jun 21, 2016 at 1:00 AM,  <mschwan@opentext.com> wrote:
> > > Page: https://www.postgresql.org/docs/9.5/static/sql-dropextension.html
> > > Description:
> > > I dropped an extension in my database with a function dependency.  The
> > > function was dropped (without messages of dependencies) and leaving the
> > > function intact.
> > > The lines &quot;DROP EXTENSION removes extensions from the database. Dropping an
> > > extension causes its component objects to be dropped as well.&quot; is not clear.
> > >  It should be stated that by default the dependencies remain intact after
> > > the drop.
> > 
> > I am not following here.
> 
> I think the use case involves the user creating a function that depends
> on something (probably another function) in the extension.  So you drop
> the extension, which drops the function your own function depends on,
> but your own function remains in place.

Right; mschwan wrote private email to indicate that the function in
question is:

CREATE OR REPLACE FUNCTION public.f_unaccent(text)
  RETURNS text AS
$$
  select public.unaccent('public.unaccent', $1)
$$
  LANGUAGE sql IMMUTABLE;

so when the unaccent extension is dropped, this function remains (of
course) but it stops working.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs