[postgis-tickets] [PostGIS] #5046: Old postgis library needed to upgrade

[PostGIS]

#5046: Old postgis library needed to upgrade
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:  PostGIS 3.2.1
Component:  build/upgrade/install  |    Version:  3.2.x
 Keywords:                         |
-----------------------------------+---------------------------
 I confirmed this is an issue on my system as detailed in
 https://lists.osgeo.org/pipermail/postgis-users/2022-January/045186.html

 If you uninstall an old version of PostGIS you were using and then install
 a new version (that doesn't use the same lib file), you get this error.


 {{{
 SELECT postgis_extensions_upgrade();
 }}}


 {{{
 NOTICE:  Updating extension postgis from 3.1.4 to 3.2.0

 ERROR:  could not access file "$libdir/postgis-3": No such file or
 directory
 CONTEXT:  PL/pgSQL function _postgis_drop_function_if_needed(text,text)
 line 6 at FOR over SELECT rows
 SQL statement "ALTER EXTENSION postgis UPDATE TO "3.2.0";"
 PL/pgSQL function postgis_extensions_upgrade() line 79 at EXECUTE
 SQL state: 58P01
 }}}

 I thought we had dealt with this issue before, to allow upgrade even in
 absense of old library.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5046>
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.