[postgis-tickets] [PostGIS] #4186: Unable to upgrade from PostGIS 2.4.3 to 2.4.5

[PostGIS]

#4186: Unable to upgrade from PostGIS 2.4.3 to 2.4.5
----------------------------+---------------------------
 Reporter:  Rikiar          |      Owner:  pramsey
     Type:  defect          |     Status:  new
 Priority:  medium          |  Milestone:  PostGIS 2.4.6
Component:  postgis         |    Version:  2.4.x
 Keywords:  Upgrade, 2.4.3  |
----------------------------+---------------------------
 Hello,
 I work for Heroku Postgres, where we provide Postgres as a service for our
 customers. A fair number of these customers use the PostGIS extension,
 which we install and support. I currently am working with a customer, who
 are running PostGIS 2.4.3 on Postgres 9.6.8 and are attempting to update
 to PostGIS 2.4.4. They are encountering this error:

 {{{
 sql_error_code = 42P13 HINT:  Use DROP FUNCTION box2d_in(cstring) first.
 sql_error_code = 42P13 STATEMENT:  ALTER EXTENSION "postgis" UPDATE;
 }}}

 When attempting to follow the hint and performing the DROP FUNCTION for
 box2d_in(cstring), I get the following error:

 {{{
 DROP FUNCTION box2d_in(cstring);
 ERROR:  cannot drop function box2d_in(cstring) because extension postgis
 requires it
 HINT:  You can drop extension postgis instead.
 }}}

 I didn't see anything in the release notes for 2.4.5 regarding the
 behavior I am seeing, so what I am seeing seems to indicate that there is
 an error in the PostGIS update script. If this seems inaccurate, please
 let me know.

 To reproduce:

 * Create a 9.6.8 Postgres cluster
 * Install PostGIS 2.4.3
 * Run {{{CREATE EXTENSION postgis;}}}
 * Install PostGIS 2.4.4
 * Run {{{ALTER EXTENSION "postgis" UPDATE;}}}

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