Re: ALTER EXTENSION DROP FUNCTION not working ?

From: Sandro Santilli <strk(at)keybit(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: ALTER EXTENSION DROP FUNCTION not working ?
Date: 2016-02-09 09:46:28
Message-ID: 20160209094628.GB3901@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Feb 09, 2016 at 10:33:42AM +0100, Sandro Santilli wrote:

> https://trac.osgeo.org/postgis/ticket/3450#comment:23
>
> Basically I'm getting:
>
> ERROR: cannot drop function pgis_twkb_accum_finalfn(internal) because other objects depend on it
> DETAIL: extension postgis depends on function pgis_twkb_accum_finalfn(internal)

Figured: the "pgis_twkb_accum_finalfn(internal)" function is not
a _direct_ dependency of extension "postgis", but is needed for
an aggregate which is still registered.

So this is more an annoyance than a bug, being the non-clear error
message about what's the direct dependent object that prevents
the drop.

--strk;

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2016-02-09 09:46:34 Re: checkpointer continuous flushing - V16
Previous Message Sandro Santilli 2016-02-09 09:33:42 ALTER EXTENSION DROP FUNCTION not working ?