[postgis-devel] cannot postgis_extensions_upgrade() due to some sfcgal issue

[Sandro Santilli]

Starting situation (I wish postgis_full_version() returned SETOF...)

 POSTGIS="3.0.0dev r17291" [EXTENSION] PGSQL="96"
 GEOS="3.8.0dev-CAPI-1.11.0 397f07e0"
 SFCGAL="1.3.6"
 PROJ="Rel. 4.9.3, 15 August 2016"
 GDAL="GDAL 2.3.0dev, released 2017/99/99"
 LIBXML="2.9.4"
 LIBJSON="0.12.1"
 LIBPROTOBUF="1.2.1"
 (core procs from "3.0.0dev r16892" need upgrade)
 RASTER
 (raster lib from "3.0.0dev r16841" need upgrade)
 (raster procs from "3.0.0dev r16841" need upgrade)
 (sfcgal procs from "3.0.0dev r16878" need upgrade)

Attempt to upgrade:

	# select postgis_extensions_upgrade();
	WARNING:  'postgis.gdal_datapath' is already set and cannot be changed until you reconnect
	WARNING:  'postgis.gdal_enabled_drivers' is already set and cannot be changed until you reconnect
	WARNING:  'postgis.enable_outdb_rasters' is already set and cannot be changed until you reconnect
	ERROR:  cannot drop function st_generatepoints(geometry,numeric) because extension postgis requires it
	HINT:  You can drop extension postgis instead.
	CONTEXT:  SQL statement "CREATE EXTENSION postgis_sfcgal FROM unpackaged"
	PL/pgSQL function postgis_extensions_upgrade() line 48 at EXECUTE

Known issue ?

--strk;