[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:
------------------------------------+---------------------------
Description changed by strk:

Old description:

> Putting in this ticket for Dan Worthman as he's having issues setting up
> an osgeo account.
>
> I'm having some issues with upgrading my postgis extension from 3.2.3 to
> 3.3.2. I'm on postgres engine 14.7 on AWS RDS Aurora, and my failure is
> coming from running SELECT postgis_extensions_upgrade();
>

> ERROR:  cannot change name of input parameter "geometrya"
>
> HINT:  Use DROP FUNCTION st_orderingequals(geometry,geometry) first.
>

>
> I was told this is fixed in unreleased 3.4.1
> https://trac.osgeo.org/postgis/changeset/e428b70577bd51d3924346d9f0124a6d37ef4ff8/git
> and I would like to request a backport to the 3.3 branch.
>
> I was also directed to try dropping the function:
>
> postgres=> DROP FUNCTION st_orderingequals(geometry,geometry);
>
> ERROR:  cannot drop function st_orderingequals(geometry,geometry) because
> extension postgis requires it
>
> HINT:  You can drop extension postgis instead.
>

>
> Strk told me to try `alter extension postgis drop function` but I am not
> permitted to do this in RDS Aurora (I opened a support ticket with AWS to
> try to solve the problem from this angle)
>

> postgres=> alter extension postgis drop function st_orderingequals;
>
> ERROR: must be owner of extension postgis
>

>
> They also told me that according to git log, commit 6082ff04f3 fixed the
> problem but since I am still facing the issue they recommended I open a
> ticket.
>

>
> Here is my search path:
>
> postgres=> show search_path;
>
>         search_path
>
> ---------------------------
>
> "$user", public, topology
>
> (1 row)

New description:

 Putting in this ticket for Dan Worthman as he's having issues setting up
 an osgeo account.

 I'm having some issues with upgrading my postgis extension from 3.2.3 to
 3.3.2. I'm on postgres engine 14.7 on AWS RDS Aurora, and my failure is
 coming from running SELECT postgis_extensions_upgrade();


 ERROR:  cannot change name of input parameter "geometrya"

 HINT:  Use DROP FUNCTION st_orderingequals(geometry,geometry) first.



 I was told this is fixed in unreleased 3.4.1
 https://trac.osgeo.org/postgis/changeset/e428b70577bd51d3924346d9f0124a6d37ef4ff8/git
 and I would like to request a backport to the 3.3 branch.

 I was also directed to try dropping the function:

 postgres=> DROP FUNCTION st_orderingequals(geometry,geometry);

 ERROR:  cannot drop function st_orderingequals(geometry,geometry) because
 extension postgis requires it

 HINT:  You can drop extension postgis instead.



 Strk told me to try `alter extension postgis drop function` but I am not
 permitted to do this in RDS Aurora (I opened a support ticket with AWS to
 try to solve the problem from this angle)


 postgres=> alter extension postgis drop function st_orderingequals;

 ERROR: must be owner of extension postgis



 They also told me that according to git log, commit [6082ff04f3/git] fixed
 the problem but since I am still facing the issue they recommended I open
 a ticket.



 Here is my search path:

 postgres=> show search_path;

         search_path

 ---------------------------

 "$user", public, topology

 (1 row)

--
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5545#comment:5>
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.