[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-673-gac81ed5c4

git at osgeo.org git at osgeo.org
Mon Feb 27 13:10:19 PST 2023


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  ac81ed5c4b22e32ee7cf33bf4931b364b5bd3465 (commit)
       via  b01690abf7705fb0a274c1afb61aca639de6b39b (commit)
      from  9e5cfe3f3a6e9ae0abf4cbb173b450b38866963c (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit ac81ed5c4b22e32ee7cf33bf4931b364b5bd3465
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Feb 27 20:23:08 2023 +0100

    Analyze more files for generating the postgis_restore.pl skiplist
    
    Rather than just the obsoleted objects, use the uninstall scripts
    to also skip whatever is installed by *current* version of postgis.
    
    Update the hardcoded skiplist to drop what we can generate
    
    References #5348

diff --git a/utils/Makefile.in b/utils/Makefile.in
index 0bdd56d12..e30676fd2 100644
--- a/utils/Makefile.in
+++ b/utils/Makefile.in
@@ -41,29 +41,53 @@ SCRIPTS = \
 all: $(SCRIPTS_built)
 
 DROP_FILES = \
-  $(top_srcdir)/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in \
-  $(top_srcdir)/raster/rt_pg/rtpostgis_drop.sql.in \
-  $(top_srcdir)/postgis/postgis_after_upgrade.sql \
-  $(top_srcdir)/postgis/postgis_before_upgrade.sql
-
-postgis_restore_data.hardcoded: postgis_restore.pl.in
+	$(top_srcdir)/raster/rt_pg/rtpostgis_upgrade_cleanup.sql.in \
+	$(top_srcdir)/raster/rt_pg/rtpostgis_drop.sql.in \
+	$(top_srcdir)/postgis/postgis_after_upgrade.sql \
+	$(top_srcdir)/postgis/postgis_before_upgrade.sql \
+	$(top_srcdir)/topology/topology_after_upgrade.sql.in \
+	$(top_srcdir)/topology/topology_before_upgrade.sql.in \
+	$(top_builddir)/postgis/uninstall_postgis.sql \
+	$(top_builddir)/postgis/uninstall_legacy.sql \
+	$(top_builddir)/sfcgal/uninstall_sfcgal.sql \
+	$(top_builddir)/raster/rt_pg/uninstall_rtpostgis.sql \
+	$(top_builddir)/topology/uninstall_topology.sql
+
+$(top_builddir)/postgis/uninstall_postgis.sql:
+	$(MAKE) -C ../postgis uninstall_postgis.sql
+
+$(top_builddir)/postgis/uninstall_legacy.sql:
+	$(MAKE) -C ../postgis uninstall_legacy.sql
+
+$(top_builddir)/sfcgal/uninstall_sfcgal.sql:
+	$(MAKE) -C ../sfcgal uninstall_sfcgal.sql
+
+$(top_builddir)/raster/rt_pg/uninstall_rtpostgis.sql:
+	$(MAKE) -C ../raster/rt_pg uninstall_rtpostgis.sql
+
+$(top_builddir)/topology/uninstall_topology.sql:
+	$(MAKE) -C ../topology/ uninstall_topology.sql
+
+postgis_restore_data.hardcoded: postgis_restore.pl.in Makefile
 	sed -e '1,/^__END__/d' $< \
 		| sort -u \
 		> $@
 
-postgis_restore_data.generated: $(DROP_FILES)
+postgis_restore_data.generated: $(DROP_FILES) Makefile
 	grep '^DROP FUNCTION IF EXISTS' $(DROP_FILES) | \
     cut -d: -f2 | sed 's/^DROP FUNCTION IF EXISTS //' | \
     sed 's/ *, */,/g' | \
     sed 's/ *( */(/g' | \
     sed 's/ *) */)/g' | \
     tr '[A-Z]' '[a-z]' | \
+    sed 's/topology\.//g' | \
     sed 's/varchar/character varying/g' | \
     sed 's/float8/double precision/g' | \
     sed 's/\<int\>/integer/g' | \
     sed 's/\<int4\>/integer/g' | \
     sed 's/\<int8\>/bigint/g' | \
     sed 's/\(.*\); *\(--.*\)\?/FUNCTION \1/' \
+		| sort \
 		> $@
 
 postgis_restore.pl: postgis_restore.pl.in postgis_restore_data.hardcoded postgis_restore_data.generated Makefile
diff --git a/utils/postgis_restore.pl.in b/utils/postgis_restore.pl.in
index e82e604f3..9edb816bd 100644
--- a/utils/postgis_restore.pl.in
+++ b/utils/postgis_restore.pl.in
@@ -1349,7 +1349,6 @@ DEFAULT topology id
 DOMAIN topoelement
 DOMAIN topoelementarray
 FK CONSTRAINT layer layer_topology_id_fkey
-FUNCTION addauth(text)
 FUNCTION addedge(character varying, geometry)
 FUNCTION addface(character varying, geometry, boolean)
 FUNCTION addgeometrycolumn(character varying, character varying, character varying, character varying, integer, character varying, integer, boolean)
@@ -1391,26 +1390,8 @@ FUNCTION asgml(topogeometry, text, integer, integer, regclass)
 FUNCTION asgml(topogeometry, text, integer, integer, regclass, text)
 FUNCTION asgml(topogeometry, text, integer, integer, regclass, text, integer)
 FUNCTION astopojson(topogeometry, regclass)
-FUNCTION box2d(box3d)
-FUNCTION box2df_in(cstring)
-FUNCTION box2df_out(box2df)
-FUNCTION box2d(geometry)
-FUNCTION box2d_in(cstring)
-FUNCTION box2d_out(box2d)
-FUNCTION box3d(box2d)
-FUNCTION box3d(geometry)
-FUNCTION box3d_in(cstring)
-FUNCTION box3d_out(box3d)
-FUNCTION box3d(raster)
-FUNCTION box3dtobox(box3d)
-FUNCTION box(box3d)
-FUNCTION box(geometry)
-FUNCTION bytea(geography)
-FUNCTION bytea(geometry)
-FUNCTION bytea(raster)
 FUNCTION checkauth(text, text)
 FUNCTION checkauth(text, text, text)
-FUNCTION checkauthtrigger()
 FUNCTION _checkedgelinking(integer, integer, integer, integer)
 FUNCTION cleartopogeom(topogeometry)
 FUNCTION contains_2d(box2df, box2df)
@@ -1419,11 +1400,9 @@ FUNCTION contains_2d(geometry, box2df)
 FUNCTION copytopology(character varying, character varying)
 FUNCTION createtopogeom(character varying, integer, integer)
 FUNCTION createtopogeom(character varying, integer, integer, topoelementarray)
-FUNCTION createtopology(character varying)
 FUNCTION createtopology(character varying, integer)
 FUNCTION createtopology(character varying, integer, double precision)
 FUNCTION createtopology(character varying, integer, double precision, boolean)
-FUNCTION disablelongtransactions()
 FUNCTION dropgeometrycolumn(character varying, character varying)
 FUNCTION dropgeometrycolumn(character varying, character varying, character varying)
 FUNCTION dropgeometrycolumn(character varying, character varying, character varying, character varying)
@@ -1452,7 +1431,6 @@ FUNCTION _drop_raster_constraint_spatially_unique(name, name, name)
 FUNCTION _drop_raster_constraint_srid(name, name, name)
 FUNCTION droptopogeometrycolumn(character varying, character varying, character varying)
 FUNCTION droptopology(character varying)
-FUNCTION enablelongtransactions()
 FUNCTION equals(geometry, geometry)
 FUNCTION equals(topogeometry, topogeometry)
 FUNCTION findlayer(integer, integer)
@@ -1460,23 +1438,15 @@ FUNCTION findlayer(name, name, name)
 FUNCTION findlayer(regclass, name)
 FUNCTION findlayer(topogeometry)
 FUNCTION find_srid(character varying, character varying, character varying)
-FUNCTION findtopology(integer)
 FUNCTION findtopology(name, name, name)
 FUNCTION findtopology(regclass, name)
-FUNCTION findtopology(text)
-FUNCTION findtopology(topogeometry)
 FUNCTION geog_brin_inclusion_add_value(internal, internal, internal, internal)
-FUNCTION geography_analyze(internal)
-FUNCTION geography(bytea)
 FUNCTION geography_cmp(geography, geography)
 FUNCTION geography_distance_knn(geography, geography)
 FUNCTION geography_eq(geography, geography)
 FUNCTION geography_ge(geography, geography)
 FUNCTION geography(geography, integer, boolean)
-FUNCTION geography(geometry)
-FUNCTION geography_gist_compress(internal)
 FUNCTION geography_gist_consistent(internal, geography, integer)
-FUNCTION geography_gist_decompress(internal)
 FUNCTION geography_gist_distance(internal, geography, integer)
 FUNCTION geography_gist_penalty(internal, internal, internal)
 FUNCTION geography_gist_picksplit(internal, internal)
@@ -1486,27 +1456,18 @@ FUNCTION geography_gt(geography, geography)
 FUNCTION geography_in(cstring, oid, integer)
 FUNCTION geography_le(geography, geography)
 FUNCTION geography_lt(geography, geography)
-FUNCTION geography_out(geography)
 FUNCTION geography_overlaps(geography, geography)
 FUNCTION geography_recv(internal, oid, integer)
-FUNCTION geography_send(geography)
 FUNCTION geography_spgist_choose_nd(internal, internal)
-FUNCTION geography_spgist_compress_nd(internal)
 FUNCTION geography_spgist_config_nd(internal, internal)
 FUNCTION geography_spgist_inner_consistent_nd(internal, internal)
 FUNCTION geography_spgist_leaf_consistent_nd(internal, internal)
 FUNCTION geography_spgist_picksplit_nd(internal, internal)
-FUNCTION geography_typmod_in(cstring[])
-FUNCTION geography_typmod_out(integer)
 FUNCTION geom2d_brin_inclusion_add_value(internal, internal, internal, internal)
 FUNCTION geom3d_brin_inclusion_add_value(internal, internal, internal, internal)
 FUNCTION geom4d_brin_inclusion_add_value(internal, internal, internal, internal)
 FUNCTION geometry_above(geometry, geometry)
-FUNCTION geometry_analyze(internal)
 FUNCTION geometry_below(geometry, geometry)
-FUNCTION geometry(box2d)
-FUNCTION geometry(box3d)
-FUNCTION geometry(bytea)
 FUNCTION geometry_cmp(geometry, geometry)
 FUNCTION geometry_contained_3d(geometry, geometry)
 FUNCTION geometry_contained_by_raster(geometry, raster)
@@ -1519,14 +1480,9 @@ FUNCTION geometry_distance_centroid_nd(geometry, geometry)
 FUNCTION geometry_distance_cpa(geometry, geometry)
 FUNCTION geometry_eq(geometry, geometry)
 FUNCTION geometry_ge(geometry, geometry)
-FUNCTION geometry(geography)
 FUNCTION geometry(geometry, integer, boolean)
-FUNCTION geometry_gist_compress_2d(internal)
-FUNCTION geometry_gist_compress_nd(internal)
 FUNCTION geometry_gist_consistent_2d(internal, geometry, integer)
 FUNCTION geometry_gist_consistent_nd(internal, geometry, integer)
-FUNCTION geometry_gist_decompress_2d(internal)
-FUNCTION geometry_gist_decompress_nd(internal)
 FUNCTION geometry_gist_distance_2d(internal, geometry, integer)
 FUNCTION geometry_gist_distance_nd(internal, geometry, integer)
 FUNCTION geometry_gist_penalty_2d(internal, internal, internal)
@@ -1535,16 +1491,12 @@ FUNCTION geometry_gist_picksplit_2d(internal, internal)
 FUNCTION geometry_gist_picksplit_nd(internal, internal)
 FUNCTION geometry_gist_same_2d(geometry, geometry, internal)
 FUNCTION geometry_gist_same_nd(geometry, geometry, internal)
-FUNCTION geometry_gist_sortsupport_2d(internal)
 FUNCTION geometry_gist_union_2d(bytea, internal)
 FUNCTION geometry_gist_union_nd(bytea, internal)
 FUNCTION geometry_gt(geometry, geometry)
-FUNCTION geometry_hash(geometry)
-FUNCTION geometry_in(cstring)
 FUNCTION geometry_left(geometry, geometry)
 FUNCTION geometry_le(geometry, geometry)
 FUNCTION geometry_lt(geometry, geometry)
-FUNCTION geometry_out(geometry)
 FUNCTION geometry_overabove(geometry, geometry)
 FUNCTION geometry_overbelow(geometry, geometry)
 FUNCTION geometry_overlaps_3d(geometry, geometry)
@@ -1552,24 +1504,15 @@ FUNCTION geometry_overlaps(geometry, geometry)
 FUNCTION geometry_overlaps_nd(geometry, geometry)
 FUNCTION geometry_overleft(geometry, geometry)
 FUNCTION geometry_overright(geometry, geometry)
-FUNCTION geometry(path)
-FUNCTION geometry(point)
-FUNCTION geometry(polygon)
 FUNCTION geometry_raster_contain(geometry, raster)
 FUNCTION geometry_raster_overlap(geometry, raster)
-FUNCTION geometry_recv(internal)
 FUNCTION geometry_right(geometry, geometry)
 FUNCTION geometry_same_3d(geometry, geometry)
 FUNCTION geometry_same(geometry, geometry)
 FUNCTION geometry_same_nd(geometry, geometry)
-FUNCTION geometry_send(geometry)
-FUNCTION geometry_sortsupport(internal)
 FUNCTION geometry_spgist_choose_2d(internal, internal)
 FUNCTION geometry_spgist_choose_3d(internal, internal)
 FUNCTION geometry_spgist_choose_nd(internal, internal)
-FUNCTION geometry_spgist_compress_2d(internal)
-FUNCTION geometry_spgist_compress_3d(internal)
-FUNCTION geometry_spgist_compress_nd(internal)
 FUNCTION geometry_spgist_config_2d(internal, internal)
 FUNCTION geometry_spgist_config_3d(internal, internal)
 FUNCTION geometry_spgist_config_nd(internal, internal)
@@ -1582,23 +1525,15 @@ FUNCTION geometry_spgist_leaf_consistent_nd(internal, internal)
 FUNCTION geometry_spgist_picksplit_2d(internal, internal)
 FUNCTION geometry_spgist_picksplit_3d(internal, internal)
 FUNCTION geometry_spgist_picksplit_nd(internal, internal)
-FUNCTION geometry(text)
 FUNCTION geometry(topogeometry)
-FUNCTION geometrytype(geography)
-FUNCTION geometrytype(geometry)
 FUNCTION geometrytype(topogeometry)
-FUNCTION geometry_typmod_in(cstring[])
-FUNCTION geometry_typmod_out(integer)
 FUNCTION geometry_within(geometry, geometry)
 FUNCTION geometry_within_nd(geometry, geometry)
-FUNCTION geomfromewkb(bytea)
-FUNCTION geomfromewkt(text)
 FUNCTION getedgebypoint(character varying, geometry, double precision)
 FUNCTION getfacebypoint(character varying, geometry, double precision)
 FUNCTION getfacecontainingpoint(text, geometry)
 FUNCTION getnodebypoint(character varying, geometry, double precision)
 FUNCTION getnodeedges(character varying, integer)
-FUNCTION get_proj4_from_srid(integer)
 FUNCTION getringedges(character varying, integer, integer)
 FUNCTION gettopogeomelementarray(character varying, integer, integer)
 FUNCTION gettopogeomelementarray(topogeometry)
@@ -1607,9 +1542,6 @@ FUNCTION gettopogeomelements(topogeometry)
 FUNCTION gettopologyid(character varying)
 FUNCTION gettopologyname(integer)
 FUNCTION gettopologysrid(character varying)
-FUNCTION gettransactionid()
-FUNCTION gidx_in(cstring)
-FUNCTION gidx_out(gidx)
 FUNCTION gserialized_gist_joinsel_2d(internal, oid, internal, smallint)
 FUNCTION gserialized_gist_joinsel_nd(internal, oid, internal, smallint)
 FUNCTION gserialized_gist_sel_2d(internal, oid, internal, integer)
@@ -1620,12 +1552,10 @@ FUNCTION is_contained_2d(box2df, geometry)
 FUNCTION is_contained_2d(geometry, box2df)
 FUNCTION jsonb(geometry)
 FUNCTION json(geometry)
-FUNCTION layertrigger()
 FUNCTION lockrow(text, text, text)
 FUNCTION lockrow(text, text, text, text)
 FUNCTION lockrow(text, text, text, text, timestamp without time zone)
 FUNCTION lockrow(text, text, text, timestamp without time zone)
-FUNCTION longtransactionsenabled()
 FUNCTION overlaps_2d(box2df, box2df)
 FUNCTION overlaps_2d(box2df, geometry)
 FUNCTION overlaps_2d(geometry, box2df)
@@ -1637,97 +1567,41 @@ FUNCTION overlaps_nd(gidx, geometry)
 FUNCTION overlaps_nd(gidx, gidx)
 FUNCTION _overview_constraint_info(name, name, name)
 FUNCTION _overview_constraint(raster, integer, name, name, name)
-FUNCTION path(geometry)
-FUNCTION pgis_asflatgeobuf_finalfn(internal)
 FUNCTION pgis_asflatgeobuf_transfn(internal, anyelement)
 FUNCTION pgis_asflatgeobuf_transfn(internal, anyelement, boolean)
 FUNCTION pgis_asflatgeobuf_transfn(internal, anyelement, boolean, text)
-FUNCTION pgis_asgeobuf_finalfn(internal)
 FUNCTION pgis_asgeobuf_transfn(internal, anyelement)
 FUNCTION pgis_asgeobuf_transfn(internal, anyelement, text)
 FUNCTION pgis_asmvt_combinefn(internal, internal)
 FUNCTION pgis_asmvt_deserialfn(bytea, internal)
-FUNCTION pgis_asmvt_finalfn(internal)
-FUNCTION pgis_asmvt_serialfn(internal)
 FUNCTION pgis_asmvt_transfn(internal, anyelement)
 FUNCTION pgis_asmvt_transfn(internal, anyelement, text)
 FUNCTION pgis_asmvt_transfn(internal, anyelement, text, integer)
 FUNCTION pgis_asmvt_transfn(internal, anyelement, text, integer, text)
 FUNCTION pgis_asmvt_transfn(internal, anyelement, text, integer, text, text)
-FUNCTION pgis_geometry_union_finalfn(internal)
 FUNCTION pgis_geometry_accum_transfn(internal, geometry)
 FUNCTION pgis_geometry_accum_transfn(internal, geometry, double precision)
 FUNCTION pgis_geometry_accum_transfn(internal, geometry, double precision, integer)
-FUNCTION pgis_geometry_clusterintersecting_finalfn(internal)
-FUNCTION pgis_geometry_clusterwithin_finalfn(internal)
-FUNCTION pgis_geometry_collect_finalfn(internal)
-FUNCTION pgis_geometry_makeline_finalfn(internal)
-FUNCTION pgis_geometry_polygonize_finalfn(internal)
 FUNCTION pgis_geometry_union_parallel_combinefn(internal, internal)
 FUNCTION pgis_geometry_union_parallel_deserialfn(bytea, internal)
-FUNCTION pgis_geometry_union_parallel_finalfn(internal)
-FUNCTION pgis_geometry_union_parallel_serialfn(internal)
 FUNCTION pgis_geometry_union_parallel_transfn(internal, geometry)
 FUNCTION pgis_geometry_union_parallel_transfn(internal, geometry, double precision)
-FUNCTION point(geometry)
-FUNCTION polygon(geometry)
 FUNCTION polygonize(character varying)
 FUNCTION populate_geometry_columns(boolean)
 FUNCTION populate_geometry_columns(oid, boolean)
-FUNCTION populate_topology_layer()
-FUNCTION postgis_addbbox(geometry)
-FUNCTION postgis_cache_bbox()
 FUNCTION postgis_constraint_dims(text, text, text)
 FUNCTION postgis_constraint_srid(text, text, text)
 FUNCTION postgis_constraint_type(text, text, text)
 FUNCTION _postgis_deprecate(text, text, text)
-FUNCTION postgis_dropbbox(geometry)
 FUNCTION postgis_extensions_upgrade()
 FUNCTION postgis_extensions_upgrade(text)
-FUNCTION postgis_full_version()
-FUNCTION postgis_gdal_version()
-FUNCTION postgis_geos_compiled_version()
-FUNCTION postgis_geos_noop(geometry)
-FUNCTION postgis_geos_version()
-FUNCTION postgis_getbbox(geometry)
-FUNCTION postgis_hasbbox(geometry)
 FUNCTION _postgis_index_extent(regclass, text)
-FUNCTION postgis_index_supportfn(internal)
 FUNCTION _postgis_join_selectivity(regclass, text, regclass, text, text)
-FUNCTION postgis_lib_build_date()
-FUNCTION postgis_libjson_version()
-FUNCTION postgis_liblwgeom_version()
-FUNCTION postgis_libprotobuf_version()
-FUNCTION postgis_lib_revision()
-FUNCTION postgis_lib_version()
-FUNCTION postgis_libxml_version()
-FUNCTION postgis_noop(geometry)
-FUNCTION postgis_noop(raster)
-FUNCTION _postgis_pgsql_version()
-FUNCTION postgis_proj_version()
-FUNCTION postgis_raster_lib_build_date()
-FUNCTION postgis_raster_lib_version()
-FUNCTION postgis_raster_scripts_installed()
-FUNCTION postgis_scripts_build_date()
-FUNCTION postgis_scripts_installed()
-FUNCTION _postgis_scripts_pgsql_version()
-FUNCTION postgis_scripts_released()
 FUNCTION _postgis_selectivity(regclass, text, geometry, text)
-FUNCTION postgis_sfcgal_full_version()
-FUNCTION postgis_sfcgal_noop(geometry)
-FUNCTION postgis_sfcgal_scripts_installed()
-FUNCTION postgis_sfcgal_version()
 FUNCTION _postgis_stats(regclass, text, text)
-FUNCTION postgis_svn_version()
-FUNCTION postgis_topology_scripts_installed()
 FUNCTION postgis_transform_geometry(geometry, text, text, integer)
 FUNCTION postgis_transform_pipeline_geometry(geometry, text, boolean, integer)
 FUNCTION postgis_type_name(character varying, integer, boolean)
-FUNCTION postgis_typmod_dims(integer)
-FUNCTION postgis_typmod_srid(integer)
-FUNCTION postgis_typmod_type(integer)
-FUNCTION postgis_version()
-FUNCTION postgis_wagyu_version()
 FUNCTION raster_above(raster, raster)
 FUNCTION raster_below(raster, raster)
 FUNCTION _raster_constraint_info_alignment(name, name, name)
@@ -1752,10 +1626,7 @@ FUNCTION raster_contain(raster, raster)
 FUNCTION raster_eq(raster, raster)
 FUNCTION raster_geometry_contain(raster, geometry)
 FUNCTION raster_geometry_overlap(raster, geometry)
-FUNCTION raster_hash(raster)
-FUNCTION raster_in(cstring)
 FUNCTION raster_left(raster, raster)
-FUNCTION raster_out(raster)
 FUNCTION raster_overabove(raster, raster)
 FUNCTION raster_overbelow(raster, raster)
 FUNCTION raster_overlap(raster, raster)
@@ -1763,15 +1634,10 @@ FUNCTION raster_overleft(raster, raster)
 FUNCTION raster_overright(raster, raster)
 FUNCTION raster_right(raster, raster)
 FUNCTION raster_same(raster, raster)
-FUNCTION relationtrigger()
 FUNCTION removeunusedprimitives(text, geometry)
 FUNCTION renametopogeometrycolumn(regclass, name, name)
 FUNCTION renametopology(character varying, character varying)
-FUNCTION spheroid_in(cstring)
-FUNCTION spheroid_out(spheroid)
-FUNCTION st_3darea(geometry)
 FUNCTION st_3dclosestpoint(geometry, geometry)
-FUNCTION st_3dconvexhull(geometry)
 FUNCTION _st_3ddfullywithin(geometry, geometry, double precision)
 FUNCTION st_3ddfullywithin(geometry, geometry, double precision)
 FUNCTION st_3ddifference(geometry, geometry)
@@ -1781,12 +1647,10 @@ FUNCTION st_3ddwithin(geometry, geometry, double precision)
 FUNCTION st_3dintersection(geometry, geometry)
 FUNCTION _st_3dintersects(geometry, geometry)
 FUNCTION st_3dintersects(geometry, geometry)
-FUNCTION st_3dlength(geometry)
 FUNCTION st_3dlineinterpolatepoint(geometry, double precision)
 FUNCTION st_3dlongestline(geometry, geometry)
 FUNCTION st_3dmakebox(geometry, geometry)
 FUNCTION st_3dmaxdistance(geometry, geometry)
-FUNCTION st_3dperimeter(geometry)
 FUNCTION st_3dshortestline(geometry, geometry)
 FUNCTION st_3dunion(geometry, geometry)
 FUNCTION st_addband(raster, addbandarg[])
@@ -1819,7 +1683,6 @@ FUNCTION st_approxhistogram(raster, integer, boolean, double precision, integer,
 FUNCTION st_approxhistogram(raster, integer, double precision)
 FUNCTION st_approxhistogram(raster, integer, double precision, integer, boolean)
 FUNCTION st_approxhistogram(raster, integer, double precision, integer, double precision[], boolean)
-FUNCTION st_approximatemedialaxis(geometry)
 FUNCTION st_approxquantile(raster, boolean, double precision)
 FUNCTION st_approxquantile(raster, double precision)
 FUNCTION st_approxquantile(raster, double precision[])
@@ -1833,35 +1696,23 @@ FUNCTION st_approxsummarystats(raster, boolean, double precision)
 FUNCTION st_approxsummarystats(raster, double precision)
 FUNCTION st_approxsummarystats(raster, integer, boolean, double precision)
 FUNCTION st_approxsummarystats(raster, integer, double precision)
-FUNCTION st_area2d(geometry)
 FUNCTION st_area(geography, boolean)
-FUNCTION st_area(geometry)
-FUNCTION st_area(text)
-FUNCTION st_asbinary(geography)
 FUNCTION st_asbinary(geography, text)
-FUNCTION st_asbinary(geometry)
 FUNCTION st_asbinary(geometry, text)
 FUNCTION st_asbinary(raster, boolean)
 FUNCTION st_asencodedpolyline(geometry, integer)
-FUNCTION st_asewkb(geometry)
 FUNCTION st_asewkb(geometry, text)
-FUNCTION st_asewkt(geography)
 FUNCTION st_asewkt(geography, integer)
-FUNCTION st_asewkt(geometry)
 FUNCTION st_asewkt(geometry, integer)
-FUNCTION st_asewkt(text)
 FUNCTION st_asgdalraster(raster, text, text[], integer)
 FUNCTION st_asgeojson(geography, integer, integer)
 FUNCTION st_asgeojson(geometry, integer, integer)
 FUNCTION st_asgeojson(record, text, integer, boolean)
-FUNCTION st_asgeojson(text)
 FUNCTION st_asgml(geography, integer, integer, text, text)
 FUNCTION st_asgml(geometry, integer, integer)
 FUNCTION st_asgml(integer, geography, integer, integer, text, text)
 FUNCTION _st_asgml(integer, geometry, integer, integer, text, text)
 FUNCTION st_asgml(integer, geometry, integer, integer, text, text)
-FUNCTION st_asgml(text)
-FUNCTION st_ashexewkb(geometry)
 FUNCTION st_ashexewkb(geometry, text)
 FUNCTION st_ashexwkb(raster, boolean)
 FUNCTION st_asjpeg(raster, integer, integer)
@@ -1871,7 +1722,6 @@ FUNCTION st_asjpeg(raster, integer[], text[])
 FUNCTION st_asjpeg(raster, text[])
 FUNCTION st_askml(geography, integer, text)
 FUNCTION st_askml(geometry, integer, text)
-FUNCTION st_askml(text)
 FUNCTION st_aslatlontext(geometry, text)
 FUNCTION st_asmarc21(geometry, text)
 FUNCTION st_asmvtgeom(geometry, box2d, integer, integer, boolean)
@@ -1896,12 +1746,8 @@ FUNCTION st_asraster(geometry, raster, text, double precision, double precision,
 FUNCTION st_asraster(geometry, raster, text[], double precision[], double precision[], boolean)
 FUNCTION st_assvg(geography, integer, integer)
 FUNCTION st_assvg(geometry, integer, integer)
-FUNCTION st_assvg(text)
-FUNCTION st_astext(geography)
 FUNCTION st_astext(geography, integer)
-FUNCTION st_astext(geometry)
 FUNCTION st_astext(geometry, integer)
-FUNCTION st_astext(text)
 FUNCTION st_astiff(raster, integer[], text, integer)
 FUNCTION st_astiff(raster, integer[], text[], integer)
 FUNCTION st_astiff(raster, text, integer)
@@ -1927,9 +1773,7 @@ FUNCTION st_band(raster, integer[])
 FUNCTION st_band(raster, text, character)
 FUNCTION st_bdmpolyfromtext(text, integer)
 FUNCTION st_bdpolyfromtext(text, integer)
-FUNCTION _st_bestsrid(geography)
 FUNCTION _st_bestsrid(geography, geography)
-FUNCTION st_boundary(geometry)
 FUNCTION st_boundingdiagonal(geometry, boolean)
 FUNCTION st_box2dfromgeohash(text, integer)
 FUNCTION st_buffer(geography, double precision)
@@ -1940,13 +1784,9 @@ FUNCTION st_buffer(geometry, double precision, text)
 FUNCTION st_buffer(text, double precision)
 FUNCTION st_buffer(text, double precision, integer)
 FUNCTION st_buffer(text, double precision, text)
-FUNCTION st_buildarea(geometry)
 FUNCTION st_centroid(geography, boolean)
-FUNCTION st_centroid(geometry)
-FUNCTION st_centroid(text)
 FUNCTION st_chaikinsmoothing(geometry, integer, boolean)
 FUNCTION st_changeedgegeom(character varying, integer, geometry)
-FUNCTION st_cleangeometry(geometry)
 FUNCTION st_clipbybox2d(geometry, box2d)
 FUNCTION st_clip(raster, geometry, boolean)
 FUNCTION st_clip(raster, geometry, double precision, boolean)
@@ -1958,24 +1798,19 @@ FUNCTION st_clip(raster, integer[], geometry, double precision[], boolean)
 FUNCTION st_closestpoint(geometry, geometry)
 FUNCTION st_closestpointofapproach(geometry, geometry)
 FUNCTION st_clusterdbscan(geometry, double precision, integer)
-FUNCTION st_clusterintersecting(geometry[])
 FUNCTION st_clusterkmeans(geometry, integer)
 FUNCTION st_clusterkmeans(geometry, integer, double precision)
 FUNCTION st_clusterwithin(geometry[], double precision)
-FUNCTION st_collect(geometry[])
 FUNCTION st_collect(geometry, geometry)
-FUNCTION st_collectionextract(geometry)
 FUNCTION st_collectionextract(geometry, integer)
-FUNCTION st_collectionhomogenize(geometry)
 FUNCTION _st_colormap(raster, integer, text, text)
 FUNCTION st_colormap(raster, integer, text, text)
 FUNCTION st_colormap(raster, text, text)
 FUNCTION st_combinebbox(box2d, geometry)
 FUNCTION st_combinebbox(box3d, box3d)
 FUNCTION st_combinebbox(box3d, geometry)
-FUNCTION st_concavehull(geometry, double precision, boolean)
 FUNCTION _st_concavehull(geometry)
-FUNCTION st_constraineddelaunaytriangles(geometry)
+FUNCTION st_concavehull(geometry, double precision, boolean)
 FUNCTION _st_contains(geometry, geometry)
 FUNCTION st_contains(geometry, geometry)
 FUNCTION _st_containsproperly(geometry, geometry)
@@ -1988,8 +1823,6 @@ FUNCTION st_contains(raster, integer, raster, integer)
 FUNCTION st_contains(raster, raster)
 FUNCTION st_contour(raster, integer, double precision, double precision, double precision[], boolean)
 FUNCTION _st_convertarray4ma(double precision[])
-FUNCTION st_convexhull(geometry)
-FUNCTION st_convexhull(raster)
 FUNCTION st_coorddim(geometry)
 FUNCTION _st_countagg_finalfn(agg_count)
 FUNCTION _st_countagg_transfn(agg_count, raster, boolean)
@@ -2029,7 +1862,6 @@ FUNCTION st_dfullywithin(raster, integer, raster, integer, double precision)
 FUNCTION st_dfullywithin(raster, raster, double precision)
 FUNCTION st_difference(geometry, geometry)
 FUNCTION st_difference(geometry, geometry, double precision)
-FUNCTION st_dimension(geometry)
 FUNCTION st_disjoint(geometry, geometry)
 FUNCTION st_disjoint(raster, integer, raster, integer)
 FUNCTION st_disjoint(raster, raster)
@@ -2049,10 +1881,6 @@ FUNCTION _st_distanceuncached(geography, geography, double precision, boolean)
 FUNCTION st_distinct4ma(double precision[], integer[], text[])
 FUNCTION st_distinct4ma(double precision[], text, text[])
 FUNCTION st_dumpaspolygons(raster, integer, boolean)
-FUNCTION st_dump(geometry)
-FUNCTION st_dumppoints(geometry)
-FUNCTION st_dumprings(geometry)
-FUNCTION st_dumpsegments(geometry)
 FUNCTION st_dumpvalues(raster, integer, boolean)
 FUNCTION st_dumpvalues(raster, integer[], boolean)
 FUNCTION _st_dwithin(geography, geography, double precision, boolean)
@@ -2065,9 +1893,6 @@ FUNCTION st_dwithin(raster, raster, double precision)
 FUNCTION st_dwithin(text, text, double precision)
 FUNCTION _st_dwithinuncached(geography, geography, double precision)
 FUNCTION _st_dwithinuncached(geography, geography, double precision, boolean)
-FUNCTION st_endpoint(geometry)
-FUNCTION st_envelope(geometry)
-FUNCTION st_envelope(raster)
 FUNCTION _st_equals(geometry, geometry)
 FUNCTION st_equals(geometry, geometry)
 FUNCTION st_estimatedextent(text, text)
@@ -2080,13 +1905,10 @@ FUNCTION st_expand(box3d, double precision, double precision, double precision)
 FUNCTION _st_expand(geography, double precision)
 FUNCTION st_expand(geometry, double precision)
 FUNCTION st_expand(geometry, double precision, double precision, double precision, double precision)
-FUNCTION st_exteriorring(geometry)
 FUNCTION st_extrude(geometry, double precision, double precision, double precision)
 FUNCTION st_filterbym(geometry, double precision, double precision, boolean)
 FUNCTION st_findextent(text, text)
 FUNCTION st_findextent(text, text, text)
-FUNCTION st_flipcoordinates(geometry)
-FUNCTION st_force2d(geometry)
 FUNCTION st_force3d(geometry)
 FUNCTION st_force3d(geometry, double precision)
 FUNCTION st_force3dm(geometry)
@@ -2095,58 +1917,32 @@ FUNCTION st_force3dz(geometry)
 FUNCTION st_force3dz(geometry, double precision)
 FUNCTION st_force4d(geometry)
 FUNCTION st_force4d(geometry, double precision, double precision)
-FUNCTION st_forcecollection(geometry)
-FUNCTION st_forcecurve(geometry)
-FUNCTION st_forcelhr(geometry)
-FUNCTION st_forcepolygonccw(geometry)
-FUNCTION st_forcepolygoncw(geometry)
-FUNCTION st_forcerhr(geometry)
-FUNCTION st_forcesfs(geometry)
 FUNCTION st_forcesfs(geometry, text)
 FUNCTION st_frechetdistance(geometry, geometry, double precision)
 FUNCTION st_fromflatgeobuf(anyelement, bytea)
 FUNCTION st_fromflatgeobuftotable(text, text, bytea)
 FUNCTION st_fromgdalraster(bytea, integer)
-FUNCTION st_gdaldrivers()
 FUNCTION _st_gdalwarp(raster, text, double precision, integer, double precision, double precision, double precision, double precision, double precision, double precision, integer, integer)
 FUNCTION st_generatepoints(geometry, integer)
 FUNCTION st_generatepoints(geometry, integer, integer)
-FUNCTION st_geogfromtext(text)
-FUNCTION st_geogfromwkb(bytea)
-FUNCTION st_geographyfromtext(text)
 FUNCTION st_geohash(geography, integer)
 FUNCTION st_geohash(geometry, integer)
-FUNCTION st_geomcollfromtext(text)
 FUNCTION st_geomcollfromtext(text, integer)
-FUNCTION st_geomcollfromwkb(bytea)
 FUNCTION st_geomcollfromwkb(bytea, integer)
 FUNCTION st_geometricmedian(geometry, double precision, integer, boolean)
-FUNCTION st_geometryfromtext(text)
 FUNCTION st_geometryfromtext(text, integer)
 FUNCTION st_geometryn(geometry, integer)
-FUNCTION st_geometrytype(geometry)
 FUNCTION st_geometrytype(topogeometry)
-FUNCTION st_geomfromewkb(bytea)
-FUNCTION st_geomfromewkt(text)
 FUNCTION st_geomfromgeohash(text, integer)
-FUNCTION st_geomfromgeojson(json)
-FUNCTION st_geomfromgeojson(jsonb)
-FUNCTION st_geomfromgeojson(text)
-FUNCTION st_geomfromgml(text)
 FUNCTION _st_geomfromgml(text, integer)
 FUNCTION st_geomfromgml(text, integer)
-FUNCTION st_geomfromkml(text)
 FUNCTION st_geomfrommarc21(text)
-FUNCTION st_geomfromtext(text)
 FUNCTION st_geomfromtext(text, integer)
-FUNCTION st_geomfromtwkb(bytea)
-FUNCTION st_geomfromwkb(bytea)
 FUNCTION st_geomfromwkb(bytea, integer)
 FUNCTION st_georeference(raster, text)
 FUNCTION st_geotransform(raster)
 FUNCTION st_getfaceedges(character varying, integer)
 FUNCTION st_getfacegeometry(character varying, integer)
-FUNCTION st_gmltosql(text)
 FUNCTION st_gmltosql(text, integer)
 FUNCTION _st_grayscale4ma(double precision[], integer[], text[])
 FUNCTION st_grayscale(rastbandarg[], text)
@@ -2155,7 +1951,6 @@ FUNCTION st_hasarc(geometry)
 FUNCTION st_hasnoband(raster, integer)
 FUNCTION st_hausdorffdistance(geometry, geometry)
 FUNCTION st_hausdorffdistance(geometry, geometry, double precision)
-FUNCTION st_height(raster)
 FUNCTION st_hexagon(double precision, integer, integer, geometry)
 FUNCTION st_hexagongrid(double precision, geometry)
 FUNCTION _st_hillshade4ma(double precision[], integer[], text[])
@@ -2198,44 +1993,24 @@ FUNCTION st_intersects(raster, raster)
 FUNCTION st_intersects(text, text)
 FUNCTION st_invdistweight4ma(double precision[], integer[], text[])
 FUNCTION st_inversetransformpipeline(geometry, text, integer)
-FUNCTION st_isclosed(geometry)
-FUNCTION st_iscollection(geometry)
 FUNCTION st_iscoveragetile(raster, raster, integer, integer)
-FUNCTION st_isempty(geometry)
 FUNCTION st_isempty(raster)
-FUNCTION st_isplanar(geometry)
-FUNCTION st_ispolygonccw(geometry)
-FUNCTION st_ispolygoncw(geometry)
-FUNCTION st_isring(geometry)
-FUNCTION st_issimple(geometry)
-FUNCTION st_issolid(geometry)
 FUNCTION st_isvaliddetail(geometry, integer)
-FUNCTION st_isvalid(geometry)
 FUNCTION st_isvalid(geometry, integer)
-FUNCTION st_isvalidreason(geometry)
 FUNCTION st_isvalidreason(geometry, integer)
-FUNCTION st_isvalidtrajectory(geometry)
-FUNCTION st_length2d(geometry)
 FUNCTION st_length2dspheroid(geometry, spheroid)
 FUNCTION st_length(geography, boolean)
-FUNCTION st_length(geometry)
 FUNCTION st_lengthspheroid(geometry, spheroid)
-FUNCTION st_length(text)
 FUNCTION st_letters(text, json)
 FUNCTION _st_linecrossingdirection(geometry, geometry)
 FUNCTION st_linecrossingdirection(geometry, geometry)
 FUNCTION st_linefromencodedpolyline(text, integer)
-FUNCTION st_linefrommultipoint(geometry)
-FUNCTION st_linefromtext(text)
 FUNCTION st_linefromtext(text, integer)
-FUNCTION st_linefromwkb(bytea)
 FUNCTION st_linefromwkb(bytea, integer)
 FUNCTION st_lineinterpolatepoint(geometry, double precision)
 FUNCTION st_lineinterpolatepoints(geometry, double precision, boolean)
 FUNCTION st_linelocatepoint(geometry, geometry)
-FUNCTION st_linemerge(geometry)
 FUNCTION st_linemerge(geometry, boolean)
-FUNCTION st_linestringfromwkb(bytea)
 FUNCTION st_linestringfromwkb(bytea, integer)
 FUNCTION st_linesubstring(geometry, double precision, double precision)
 FUNCTION st_linetocurve(geometry)
@@ -2250,16 +2025,12 @@ FUNCTION st_makeemptyraster(integer, integer, double precision, double precision
 FUNCTION st_makeemptyraster(integer, integer, double precision, double precision, double precision, double precision, double precision, double precision, integer)
 FUNCTION st_makeemptyraster(raster)
 FUNCTION st_makeenvelope(double precision, double precision, double precision, double precision, integer)
-FUNCTION st_makeline(geometry[])
 FUNCTION st_makeline(geometry, geometry)
 FUNCTION st_makepoint(double precision, double precision)
 FUNCTION st_makepoint(double precision, double precision, double precision)
 FUNCTION st_makepoint(double precision, double precision, double precision, double precision)
 FUNCTION st_makepointm(double precision, double precision, double precision)
-FUNCTION st_makepolygon(geometry)
 FUNCTION st_makepolygon(geometry, geometry[])
-FUNCTION st_makesolid(geometry)
-FUNCTION st_makevalid(geometry)
 FUNCTION st_makevalid(geometry, text)
 FUNCTION st_mapalgebraexpr(raster, integer, raster, integer, text, text, text, text, text, double precision)
 FUNCTION st_mapalgebraexpr(raster, integer, text, text, double precision)
@@ -2294,49 +2065,30 @@ FUNCTION st_maxdistance(geometry, geometry)
 FUNCTION st_maximuminscribedcircle(geometry)
 FUNCTION st_mean4ma(double precision[], integer[], text[])
 FUNCTION st_mean4ma(double precision[], text, text[])
-FUNCTION st_memsize(geometry)
-FUNCTION st_memsize(raster)
 FUNCTION st_metadata(raster)
-FUNCTION st_m(geometry)
 FUNCTION st_min4ma(double precision[], integer[], text[])
 FUNCTION st_min4ma(double precision[], text, text[])
 FUNCTION st_minconvexhull(raster, integer)
 FUNCTION st_mindist4ma(double precision[], integer[], text[])
 FUNCTION st_minimumboundingcircle(geometry, integer)
 FUNCTION st_minimumboundingradius(geometry)
-FUNCTION st_minimumclearance(geometry)
-FUNCTION st_minimumclearanceline(geometry)
 FUNCTION st_minkowskisum(geometry, geometry)
 FUNCTION st_minpossiblevalue(text)
 FUNCTION _st_mintolerance(character varying, geometry)
 FUNCTION _st_mintolerance(geometry)
-FUNCTION st_mlinefromtext(text)
 FUNCTION st_mlinefromtext(text, integer)
-FUNCTION st_mlinefromwkb(bytea)
 FUNCTION st_mlinefromwkb(bytea, integer)
 FUNCTION st_modedgeheal(character varying, integer, integer)
 FUNCTION st_modedgesplit(character varying, integer, geometry)
 FUNCTION st_moveisonode(character varying, integer, geometry)
-FUNCTION st_mpointfromtext(text)
 FUNCTION st_mpointfromtext(text, integer)
-FUNCTION st_mpointfromwkb(bytea)
 FUNCTION st_mpointfromwkb(bytea, integer)
-FUNCTION st_mpolyfromtext(text)
 FUNCTION st_mpolyfromtext(text, integer)
-FUNCTION st_mpolyfromwkb(bytea)
 FUNCTION st_mpolyfromwkb(bytea, integer)
-FUNCTION st_multi(geometry)
-FUNCTION st_multilinefromwkb(bytea)
-FUNCTION st_multilinestringfromtext(text)
 FUNCTION st_multilinestringfromtext(text, integer)
-FUNCTION st_multipointfromtext(text)
-FUNCTION st_multipointfromwkb(bytea)
 FUNCTION st_multipointfromwkb(bytea, integer)
-FUNCTION st_multipolyfromwkb(bytea)
 FUNCTION st_multipolyfromwkb(bytea, integer)
-FUNCTION st_multipolygonfromtext(text)
 FUNCTION st_multipolygonfromtext(text, integer)
-FUNCTION st_ndims(geometry)
 FUNCTION st_nearestvalue(raster, geometry, boolean)
 FUNCTION st_nearestvalue(raster, integer, geometry, boolean)
 FUNCTION st_nearestvalue(raster, integer, integer, boolean)
@@ -2351,29 +2103,17 @@ FUNCTION st_newedgessplit(character varying, integer, geometry)
 FUNCTION st_node(geometry)
 FUNCTION st_normalize(geometry)
 FUNCTION st_notsamealignmentreason(raster, raster)
-FUNCTION st_npoints(geometry)
-FUNCTION st_nrings(geometry)
-FUNCTION st_numbands(raster)
-FUNCTION st_numgeometries(geometry)
-FUNCTION st_numinteriorring(geometry)
-FUNCTION st_numinteriorrings(geometry)
-FUNCTION st_numpatches(geometry)
-FUNCTION st_numpoints(geometry)
 FUNCTION st_offsetcurve(geometry, double precision, text)
 FUNCTION st_optimalalphashape(geometry, boolean, integer)
 FUNCTION _st_orderingequals(geometry, geometry)
 FUNCTION st_orderingequals(geometry, geometry)
-FUNCTION st_orientation(geometry)
-FUNCTION st_orientedenvelope(geometry)
 FUNCTION _st_overlaps(geometry, geometry)
 FUNCTION st_overlaps(geometry, geometry)
 FUNCTION _st_overlaps(raster, integer, raster, integer)
 FUNCTION st_overlaps(raster, integer, raster, integer)
 FUNCTION st_overlaps(raster, raster)
 FUNCTION st_patchn(geometry, integer)
-FUNCTION st_perimeter2d(geometry)
 FUNCTION st_perimeter(geography, boolean)
-FUNCTION st_perimeter(geometry)
 FUNCTION st_pixelascentroid(raster, integer, integer)
 FUNCTION st_pixelascentroids(raster, integer, boolean)
 FUNCTION _st_pixelascentroids(raster, integer, integer, integer, boolean)
@@ -2382,37 +2122,25 @@ FUNCTION st_pixelaspoints(raster, integer, boolean)
 FUNCTION st_pixelaspolygon(raster, integer, integer)
 FUNCTION st_pixelaspolygons(raster, integer, boolean)
 FUNCTION _st_pixelaspolygons(raster, integer, integer, integer, boolean)
-FUNCTION st_pixelheight(raster)
 FUNCTION st_pixelofvalue(raster, double precision, boolean)
 FUNCTION st_pixelofvalue(raster, double precision[], boolean)
 FUNCTION st_pixelofvalue(raster, integer, double precision, boolean)
 FUNCTION st_pixelofvalue(raster, integer, double precision[], boolean)
-FUNCTION st_pixelwidth(raster)
 FUNCTION st_point(double precision, double precision)
 FUNCTION st_point(double precision, double precision, integer)
 FUNCTION st_pointfromgeohash(text, integer)
-FUNCTION st_pointfromtext(text)
 FUNCTION st_pointfromtext(text, integer)
-FUNCTION st_pointfromwkb(bytea)
 FUNCTION st_pointfromwkb(bytea, integer)
 FUNCTION st_pointinsidecircle(geometry, double precision, double precision, double precision)
 FUNCTION st_pointm(double precision, double precision, double precision, integer)
 FUNCTION st_pointn(geometry, integer)
-FUNCTION st_pointonsurface(geometry)
-FUNCTION _st_pointoutside(geography)
-FUNCTION st_points(geometry)
 FUNCTION st_pointz(double precision, double precision, double precision, integer)
 FUNCTION st_pointzm(double precision, double precision, double precision, double precision, integer)
-FUNCTION st_polyfromtext(text)
 FUNCTION st_polyfromtext(text, integer)
-FUNCTION st_polyfromwkb(bytea)
 FUNCTION st_polyfromwkb(bytea, integer)
-FUNCTION st_polygonfromtext(text)
 FUNCTION st_polygonfromtext(text, integer)
-FUNCTION st_polygonfromwkb(bytea)
 FUNCTION st_polygonfromwkb(bytea, integer)
 FUNCTION st_polygon(geometry, integer)
-FUNCTION st_polygonize(geometry[])
 FUNCTION st_polygon(raster, integer)
 FUNCTION st_project(geography, double precision, double precision)
 FUNCTION st_quantile(raster, boolean, double precision)
@@ -2432,8 +2160,6 @@ FUNCTION st_rastertoworldcoordx(raster, integer)
 FUNCTION st_rastertoworldcoordx(raster, integer, integer)
 FUNCTION st_rastertoworldcoordy(raster, integer)
 FUNCTION st_rastertoworldcoordy(raster, integer, integer)
-FUNCTION st_rastfromhexwkb(text)
-FUNCTION st_rastfromwkb(bytea)
 FUNCTION st_reclass(raster, integer, text, text, double precision)
 FUNCTION _st_reclass(raster, reclassarg[])
 FUNCTION st_reclass(raster, reclassarg[])
@@ -2462,14 +2188,12 @@ FUNCTION st_resize(raster, text, text, text, double precision)
 FUNCTION st_reskew(raster, double precision, double precision, text, double precision)
 FUNCTION st_reskew(raster, double precision, text, double precision)
 FUNCTION st_retile(regclass, name, geometry, double precision, double precision, integer, integer, text)
-FUNCTION st_reverse(geometry)
 FUNCTION st_rotate(geometry, double precision)
 FUNCTION st_rotate(geometry, double precision, double precision, double precision)
 FUNCTION st_rotate(geometry, double precision, geometry)
 FUNCTION st_rotatex(geometry, double precision)
 FUNCTION st_rotatey(geometry, double precision)
 FUNCTION st_rotatez(geometry, double precision)
-FUNCTION st_rotation(raster)
 FUNCTION _st_roughness4ma(double precision[], integer[], text[])
 FUNCTION st_roughness(raster, integer, raster, text, boolean)
 FUNCTION st_roughness(raster, integer, text, boolean)
@@ -2481,8 +2205,6 @@ FUNCTION st_scale(geometry, double precision, double precision)
 FUNCTION st_scale(geometry, double precision, double precision, double precision)
 FUNCTION st_scale(geometry, geometry)
 FUNCTION st_scale(geometry, geometry, geometry)
-FUNCTION st_scalex(raster)
-FUNCTION st_scaley(raster)
 FUNCTION st_scroll(geometry, geometry)
 FUNCTION st_segmentize(geography, double precision)
 FUNCTION st_segmentize(geometry, double precision)
@@ -2518,7 +2240,6 @@ FUNCTION st_setvalues(raster, integer, integer, integer, integer, double precisi
 FUNCTION st_setvalues(raster, integer, integer, integer, integer, integer, double precision, boolean)
 FUNCTION st_setz(raster, geometry, text, integer)
 FUNCTION st_sharedpaths(geometry, geometry)
-FUNCTION st_shiftlongitude(geometry)
 FUNCTION st_shortestline(geometry, geometry)
 FUNCTION st_simplify(geometry, double precision)
 FUNCTION st_simplify(geometry, double precision, boolean)
@@ -2526,8 +2247,6 @@ FUNCTION st_simplifypolygonhull(geometry, double precision, boolean)
 FUNCTION st_simplifypreservetopology(geometry, double precision)
 FUNCTION st_simplify(topogeometry, double precision)
 FUNCTION st_simplifyvw(geometry, double precision)
-FUNCTION st_skewx(raster)
-FUNCTION st_skewy(raster)
 FUNCTION _st_slope4ma(double precision[], integer[], text[])
 FUNCTION st_slope(raster, integer, raster, text, text, double precision, boolean)
 FUNCTION st_slope(raster, integer, text, text, double precision, boolean)
@@ -2545,20 +2264,14 @@ FUNCTION st_square(double precision, integer, integer, geometry)
 FUNCTION st_squaregrid(double precision, geometry)
 FUNCTION st_srid(geography)
 FUNCTION st_srid(geometry)
-FUNCTION st_srid(raster)
 FUNCTION st_srid(topogeometry)
-FUNCTION st_startpoint(geometry)
 FUNCTION st_stddev4ma(double precision[], integer[], text[])
 FUNCTION st_stddev4ma(double precision[], text, text[])
-FUNCTION st_straightskeleton(geometry)
 FUNCTION st_subdivide(geometry, integer)
 FUNCTION st_subdivide(geometry, integer, double precision)
 FUNCTION st_sum4ma(double precision[], integer[], text[])
 FUNCTION st_sum4ma(double precision[], text, text[])
-FUNCTION st_summary(geography)
-FUNCTION st_summary(geometry)
 FUNCTION st_summary(raster)
-FUNCTION _st_summarystats_finalfn(internal)
 FUNCTION st_summarystats(raster, boolean)
 FUNCTION st_summarystats(raster, integer, boolean)
 FUNCTION _st_summarystats(raster, integer, boolean, double precision)
@@ -2569,7 +2282,6 @@ FUNCTION st_swapordinates(geometry, cstring)
 FUNCTION st_symdifference(geometry, geometry)
 FUNCTION st_symdifference(geometry, geometry, double precision)
 FUNCTION st_symmetricdifference(geometry, geometry)
-FUNCTION st_tesselate(geometry)
 FUNCTION st_tileenvelope(integer, integer, integer, geometry)
 FUNCTION st_tileenvelope(integer, integer, integer, geometry, double precision)
 FUNCTION st_tile(raster, integer, integer, boolean, double precision)
@@ -2602,8 +2314,6 @@ FUNCTION st_tri(raster, integer, raster, text, boolean)
 FUNCTION st_tri(raster, integer, text, boolean)
 FUNCTION st_unaryunion(geometry)
 FUNCTION st_unaryunion(geometry, double precision)
-FUNCTION _st_union_finalfn(internal)
-FUNCTION st_union(geometry[])
 FUNCTION st_union(geometry, geometry)
 FUNCTION st_union(geometry, geometry, double precision)
 FUNCTION _st_union_transfn(internal, raster)
@@ -2611,8 +2321,6 @@ FUNCTION _st_union_transfn(internal, raster, integer)
 FUNCTION _st_union_transfn(internal, raster, integer, text)
 FUNCTION _st_union_transfn(internal, raster, text)
 FUNCTION _st_union_transfn(internal, raster, unionarg[])
-FUNCTION st_upperleftx(raster)
-FUNCTION st_upperlefty(raster)
 FUNCTION st_valuecount(raster, double precision, double precision)
 FUNCTION st_valuecount(raster, double precision[], double precision)
 FUNCTION _st_valuecount(raster, integer, boolean, double precision[], double precision)
@@ -2643,18 +2351,15 @@ FUNCTION st_value(raster, geometry, boolean)
 FUNCTION st_value(raster, integer, geometry, boolean, text)
 FUNCTION st_value(raster, integer, integer, boolean)
 FUNCTION st_value(raster, integer, integer, integer, boolean)
-FUNCTION st_volume(geometry)
 FUNCTION _st_voronoi(geometry, geometry, double precision, boolean)
 FUNCTION st_voronoilines(geometry, double precision, geometry)
 FUNCTION st_voronoipolygons(geometry, double precision, geometry)
-FUNCTION st_width(raster)
 FUNCTION _st_within(geometry, geometry)
 FUNCTION st_within(geometry, geometry)
 FUNCTION _st_within(raster, integer, raster, integer)
 FUNCTION st_within(raster, integer, raster, integer)
 FUNCTION st_within(raster, raster)
 FUNCTION st_wkbtosql(bytea)
-FUNCTION st_wkttosql(text)
 FUNCTION _st_worldtorastercoord(raster, double precision, double precision)
 FUNCTION st_worldtorastercoord(raster, double precision, double precision)
 FUNCTION st_worldtorastercoord(raster, geometry)
@@ -2665,19 +2370,8 @@ FUNCTION st_worldtorastercoordy(raster, double precision)
 FUNCTION st_worldtorastercoordy(raster, double precision, double precision)
 FUNCTION st_worldtorastercoordy(raster, geometry)
 FUNCTION st_wrapx(geometry, double precision, double precision)
-FUNCTION st_x(geometry)
-FUNCTION st_xmax(box3d)
-FUNCTION st_xmin(box3d)
-FUNCTION st_y(geometry)
-FUNCTION st_ymax(box3d)
-FUNCTION st_ymin(box3d)
-FUNCTION st_z(geometry)
-FUNCTION st_zmax(box3d)
-FUNCTION st_zmflag(geometry)
-FUNCTION st_zmin(box3d)
-FUNCTION text(geometry)
-FUNCTION topoelement(topogeometry)
 FUNCTION topoelementarray_append(topoelementarray, topoelement)
+FUNCTION topoelement(topogeometry)
 FUNCTION topogeo_addgeometry(character varying, geometry, double precision)
 FUNCTION topogeo_addlinestring(character varying, geometry, double precision)
 FUNCTION topogeo_addpoint(character varying, geometry, double precision)
@@ -2688,14 +2382,12 @@ FUNCTION topogeom_remelement(topogeometry, topoelement)
 FUNCTION topologysummary(character varying)
 FUNCTION totopogeom(geometry, character varying, integer, double precision)
 FUNCTION totopogeom(geometry, topogeometry, double precision)
-FUNCTION unlockrows(text)
 FUNCTION updategeometrysrid(character varying, character varying, character varying, character varying, integer)
 FUNCTION updategeometrysrid(character varying, character varying, character varying, integer)
 FUNCTION updategeometrysrid(character varying, character varying, integer)
 FUNCTION updaterastersrid(name, name, integer)
 FUNCTION _updaterastersrid(name, name, name, integer)
 FUNCTION updaterastersrid(name, name, name, integer)
-FUNCTION validatetopology(character varying)
 FUNCTION validatetopology(character varying, geometry)
 FUNCTION _validatetopologyedgelinking(geometry)
 FUNCTION _validatetopologygetfaceshellmaximaledgering(character varying, integer)

commit b01690abf7705fb0a274c1afb61aca639de6b39b
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Feb 27 20:44:07 2023 +0100

    Still allow building uninstall_sfcgal.sql when not building sfcgal

diff --git a/GNUmakefile.in b/GNUmakefile.in
index 2f9ac0530..fe1d2dc8c 100644
--- a/GNUmakefile.in
+++ b/GNUmakefile.in
@@ -133,6 +133,10 @@ distclean-local: clean-local
 		$(MAKE) -C raster/rt_pg distclean; \
 		rm -f raster/Makefile; \
 	fi
+	if test -z "@SFCGAL@"; then \
+		$(MAKE) -C sfcgal distclean; \
+		rm -f raster/Makefile; \
+	fi
 
 maintainer-clean-local: distclean-local
 	rm -f configure
diff --git a/configure.ac b/configure.ac
index e4cd41603..7c26b9382 100644
--- a/configure.ac
+++ b/configure.ac
@@ -783,6 +783,7 @@ AC_ARG_WITH([sfcgal],
 	[with_sfcgal=auto])
 
 
+POSTGIS_SFCGAL_VERSION="0"
 if test "x$with_sfcgal" != "xno"; then
   if test "x$with_sfcgal" = "xyes" -o "x$with_sfcgal" = "xauto"; then
 	  AC_PATH_PROG([SFCGAL_CONFIG], [sfcgal-config], [])
@@ -799,7 +800,6 @@ if test "x$with_sfcgal" != "xno"; then
 		SFCGAL_NUMERIC_MINOR_VERSION=`printf "%02d" $SFCGAL_MINOR_VERSION`
 		POSTGIS_SFCGAL_VERSION="$SFCGAL_MAJOR_VERSION$SFCGAL_NUMERIC_MINOR_VERSION$SFCGAL_NUMERIC_PATCH_VERSION"
 		AC_DEFINE_UNQUOTED([POSTGIS_SFCGAL_VERSION], [$POSTGIS_SFCGAL_VERSION], [SFCGAL library version at build time])
-		AC_SUBST([POSTGIS_SFCGAL_VERSION])
 
 		SFCGAL_STATIC=`$SFCGAL_CONFIG --static`
 		if test "x$SFCGAL_STATIC" = "xON"; then
@@ -808,7 +808,7 @@ if test "x$with_sfcgal" != "xno"; then
       SFCGAL="sfcgal"
 			HAVE_SFCGAL="yes"
       AC_DEFINE([HAVE_SFCGAL], [1], [Define to 1 if sfcgal is being built])
-	    SFCGAL_MAKEFILE_LIST="sfcgal/Makefile sfcgal/regress/Makefile sfcgal/regress/tests.mk extensions/postgis_sfcgal/Makefile"
+	    SFCGAL_MAKEFILE_LIST="sfcgal/regress/Makefile sfcgal/regress/tests.mk extensions/postgis_sfcgal/Makefile"
 		fi
 		if test ! "$POSTGIS_SFCGAL_VERSION" -ge 10301; then
 			AC_MSG_ERROR([PostGIS requires SFCGAL >= 1.3.1 (found $SFCGAL_VERSION)])
@@ -820,6 +820,7 @@ if test "x$with_sfcgal" != "xno"; then
 	fi
 fi
 
+AC_SUBST([POSTGIS_SFCGAL_VERSION])
 AC_SUBST([SFCGAL_VERSION])
 AC_SUBST([SFCGAL_CPPFLAGS])
 AC_SUBST([SFCGAL_LDFLAGS])
@@ -1749,6 +1750,7 @@ AC_CONFIG_FILES([GNUmakefile
    libpgcommon/cunit/Makefile
    postgis/Makefile
    postgis/sqldefines.h
+   sfcgal/Makefile
    $SFCGAL_MAKEFILE_LIST
    loader/Makefile
    loader/cunit/Makefile

-----------------------------------------------------------------------

Summary of changes:
 GNUmakefile.in              |   4 +
 configure.ac                |   6 +-
 utils/Makefile.in           |  38 +++++-
 utils/postgis_restore.pl.in | 312 +-------------------------------------------
 4 files changed, 41 insertions(+), 319 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list