SFCGAL library is out of date (for postgis_sfcgal extension)

[danieltprice]

While developing some PostGIS extension documentation, it was found that our SFCGAL library is old, making it difficult to find non-trivial examples that work.

SELECT postgis_full_version(); POSTGIS="3.3.3 2355e8e" [EXTENSION] PGSQL="160" GEOS="3.9.0-CAPI-1.16.2" SFCGAL="1.3.8" PROJ="7.2.1" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"

The latest version is 1.5.2

postgis_sfcgal

A good portion of the SFCGAL Processing and Relationship Functions require a later version of SFCGAL: https://postgis.net/docs/manual-dev/reference_sfcgal.html

https://postgis.net/docs/manual-dev/CG_YMonotonePartition.html https://postgis.net/docs/manual-dev/CG_Visibility.html https://postgis.net/docs/manual-dev/CG_AlphaShape.html https://postgis.net/docs/manual-dev/CG_ApproxConvexPartition.html https://postgis.net/docs/manual-dev/CG_ExtrudeStraightSkeleton.html https://postgis.net/docs/manual-dev/CG_GreeneApproxConvexPartition.html https://postgis.net/docs/manual-dev/CG_OptimalAlphaShape.html https://postgis.net/docs/manual-dev/CG_OptimalAlphaShape.html https://postgis.net/docs/manual-dev/CG_OptimalConvexPartition.html https://postgis.net/docs/manual-dev/CG_Visibility.html https://postgis.net/docs/manual-dev/CG_YMonotonePartition.html

Note: And most if not all require a later version of PostGIS as well (we're at 3.3.3 currently).

[tristan957]

Postponed until the Debian 12 switch: https://neondb.slack.com/archives/C04DGM6SMTM/p1721746850654279?thread_ts=1721678042.902819&cid=C04DGM6SMTM