Postgis upgrade from 3.2.3 to 3.3.2 failing on create or update function st_orderingequals

[robe]

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)