public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: Michael Paquier <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: DROP EXTENSION
Date: Tue, 21 Jun 2016 14:13:01 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

Alvaro Herrera wrote:
> Michael Paquier wrote:
> > On Tue, Jun 21, 2016 at 1:00 AM,  <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: DROP EXTENSION
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox