[postgis-tickets] [PostGIS] #5545: Postgis upgrade from 3.2.3 to 3.3.2 failing on create or update function st_orderingequals

[PostGIS]

#5545: Postgis upgrade from 3.2.3 to 3.3.2 failing on create or update function
st_orderingequals
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 3.3.5
 Component:  build/upgrade/install  |    Version:  3.4.x
Resolution:                         |   Keywords:
------------------------------------+---------------------------
Comment (by wodan):

 Hi there, thank you for the attention on this!

 {{{
 select pg_get_function_identity_arguments('st_orderingequals'::regproc);
    pg_get_function_identity_arguments
 ----------------------------------------
  geometrya geometry, geometryb geometry
 (1 row)
 }}}

 I was able to run `ALTER FUNCTION st_orderingequals(geometry, geometry)
 RENAME TO st_orderingequals_old;` but ran into further ownership issues:

 {{{
 postgres=> ALTER FUNCTION st_orderingequals(geometry, geometry) RENAME TO
 st_orderingequals_old;
 ALTER FUNCTION
 postgres=> SELECT postgis_extensions_upgrade();
 NOTICE:  Updating extension postgis from 3.2.3 to 3.3.2
 NOTICE:  Packaging extension postgis_raster
 ERROR:  Trying to add VIEW raster_columns to postgis_raster, got must be
 owner of extension postgis_raster (42501)
 CONTEXT:  PL/pgSQL function _postgis_package_object(text,text) line 28 at
 RAISE
 SQL statement "CREATE EXTENSION postgis_raster SCHEMA
 ecosystem_observation_app VERSION unpackaged;ALTER EXTENSION
 postgis_raster UPDATE TO "3.3.2""
 PL/pgSQL function postgis_extensions_upgrade() line 71 at EXECUTE
 }}}

 I opened a support ticket with AWS who told me that there are remaining
 raster functions that are no longer supported

 {{{
 unsupported raster functions exist on the instance that are causing the
 upgrade to fail:

 > SELECT postgis_full_version();

          postgis_full_version
         --------------------
          RASTER (raster procs from "2.5.1 r0" need upgrade)
 }}}

 I plan to follow https://postgis.net/documentation/tips/tip-removing-
 raster-from-2-3/, please let me know if that sounds right to you.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5545#comment:6>
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.