ALTER EXTENSION DROP FUNCTION not working ?

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

I'm seeing an issue with ALTER EXTENSION DROP FUNCTION
not fully unregistering the dependency of the function
on the extension. Commands to reproduce described here:
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)

Right after successfully running:

ALTER EXTENSION postgis DROP FUNCTION pgis_twkb_accum_finalfn(internal);

Is it a bug in PostgreSQL ? (9.3.6 running on the test machine).

--strk;

() Free GIS & Flash consultant/developer
/\ http://strk.keybit.net/services.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sandro Santilli 2016-02-09 09:46:28 Re: ALTER EXTENSION DROP FUNCTION not working ?
Previous Message Dean Rasheed 2016-02-09 09:27:04 Re: [patch] Proposal for \crosstabview in psql