[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 strk):

 robe I'm not sure if `ALTER FUNCTION` issued by user (assuming he can, as
 I suspect he still has permission issues with that) will be enough to get
 the function dropped later, because of the deprecated function not being
 unregistered from the extension.

 That said, I do see `st_orderingequals` passed to
 `_postgis_drop_function_if_needed` in postgis_before_upgrade.sql of
 stable-3.3 branch so now I wonder why that failed for the reporter. Maybe
 the function is not working in some environment ?

 For the reporter: what does this query return for you ?

 > select pg_get_function_identity_arguments('st_orderingequals'::regproc);
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5545#comment:4>
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.