[PostGIS] #5833: postgis_sfcgal deprecated functions preventing pg_upgrade

[PostGIS]

#5833: postgis_sfcgal deprecated functions preventing pg_upgrade
--------------------+---------------------------
 Reporter:  robe    |      Owner:  lbartoletti
     Type:  defect  |     Status:  new
 Priority:  medium  |  Milestone:  PostGIS 3.5.2
Component:  sfcgal  |    Version:  3.5.x
 Keywords:          |
--------------------+---------------------------
 We are lacking a postgis_sfcgal_legacy.c function which will keep track of
 all the functions we are converting to CG_.

 This currently results in this failure during pg_upgrade


 {{{
 pg_restore: while PROCESSING TOC:
 pg_restore: from TOC entry 1098; 1255 17648 FUNCTION
 st_constraineddelaunaytriangles("public"."geometry") postgres
 pg_restore: error: could not execute query: ERROR:  could not find
 function "ST_ConstrainedDelaunayTriangles" in file
 "/usr/pgsql-17/lib/postgis_sfcgal-3.so"
 Command was: CREATE FUNCTION
 "public"."st_constraineddelaunaytriangles"("public"."geometry") RETURNS
 "public"."geometry"
     LANGUAGE "c" IMMUTABLE STRICT COST 100 PARALLEL SAFE
     AS '$libdir/postgis_sfcgal-3', 'ST_ConstrainedDelaunayTriangles';

 -- For binary upgrade, handle extension membership the hard way
 ALTER EXTENSION "postgis_sfcgal" ADD FUNCTION
 "public"."st_constraineddelaunaytriangles"("public"."geometry");
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5833>
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.