[postgis-tickets] [PostGIS] #5302: PostGIS upgrade from 3.2 to 3.3 fails with deprecated function not part of PostGIS error

[PostGIS]

#5302: PostGIS upgrade from 3.2 to 3.3 fails with deprecated function not part of
PostGIS error
------------------------------------+---------------------------
  Reporter:  robe                   |      Owner:  strk
      Type:  defect                 |     Status:  closed
  Priority:  medium                 |  Milestone:  PostGIS 3.3.3
 Component:  build/upgrade/install  |    Version:  3.3.x
Resolution:  wontfix                |   Keywords:
------------------------------------+---------------------------
Changes (by robe):

 * status:  new => closed
 * resolution:   => wontfix

Comment:

 Yes it did. But wuery needs to be below because the deprecated part is at
 the end of the name.


 {{{
 SELECT proname FROM pg_proc WHERE proname like '%deprecated_by_postgis%'
 }}}


 I wonder if we should add this to the upgrade instructions.

 Note there was a pgis_geom_intersection which relied on
 st_intersection_deprecated_by_postgis_301.  On trying to drop
 st_intersection_deprecated_by_postgis_301, that failed.
 So had to drop both


 {{{
 DROP FUNCTION pgis_geom_intersection(geometry);
 DROP FUNCTION st_intersection_deprecated_by_postgis_301(geometry,geometry)
 }}}

 Only thing that puzzles me is that helper function pgis_geom_intersection,
 why it was there in the first place.  I couldn't find it listed in any
 versions of our source code.

 It's possible maybe I created it and overwrote the ST_Intersection to use
 it for some reason a very long time ago.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5302#comment:3>
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.