[postgis-tickets] [PostGIS] #3450: 2.2 -> 2.3.0dev leaves 15 function behind

[PostGIS]

#3450: 2.2 -> 2.3.0dev leaves 15 function behind
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 2.3.0
 Component:  build/upgrade/install  |    Version:  2.2.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by strk):

 PostgreSQL itself confirms that the function is unregistered from the
 postgis extension:
 {{{

 -- Drop it from extension
 strk=# begin; alter extension postgis DROP FUNCTION
 pgis_twkb_accum_finalfn(internal);
 BEGIN
 ALTER EXTENSION

 -- Drop it again from extension, showing that the removal was successful
 strk=# alter extension postgis DROP FUNCTION
 pgis_twkb_accum_finalfn(internal);
 ERROR:  function pgis_twkb_accum_finalfn(internal) is not a member of
 extension "postgis"

 -- Rollback, drop it from the extension (now we know it's successful)
 strk=# rollback; begin; alter extension postgis DROP FUNCTION
 pgis_twkb_accum_finalfn(internal);
 ROLLBACK
 BEGIN
 ALTER EXTENSION

 -- Drop the function, and PostgreSQL complains that it still registered as
 part of extension !
 strk=# DROP FUNCTION pgis_twkb_accum_finalfn(internal);
 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)
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3450#comment:23>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.