Re: ALTER EXTENSION DROP FUNCTION not working ? - Mailing list 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;