Opened 2 weeks ago

Closed 2 weeks ago

#5833 closed defect (fixed)

postgis_sfcgal deprecated functions preventing pg_upgrade

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.5.2
Component: sfcgal Version: 3.5.x
Keywords: Cc:

Description

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");

Change History (3)

comment:1 by robe, 2 weeks ago

Owner: changed from lbartoletti to robe

comment:2 by Regina Obe <lr@…>, 2 weeks ago

In 06bb82e/git:

pg_upgrade postgis_sfcgal failing
because of missing ST_ConstrainDelaunayTriangles

References #5833 for PostGIS 3.6.0

comment:3 by Regina Obe <lr@…>, 2 weeks ago

Resolution: → fixed
Status: new → closed

In 395ec22/git:

pg_upgrade postgis_sfcgal failing
because of missing
ST_ConstrainDelaunayTriangles signature

Closes #5833 for PostGIS 3.5.2

Note: See TracTickets for help on using tickets.