[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-676-g6fad44862

[git at osgeo.org]

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  6fad448625975e0016b2d1fb43f096c704bddec8 (commit)
      from  418bc7396dc535fd688e0a95b35e9e169a95eac6 (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 6fad448625975e0016b2d1fb43f096c704bddec8
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Mar 1 01:57:18 2023 +0100

    Generate TYPE skiplist for postgis_restore.pl

diff --git a/utils/create_skip_signatures.pl b/utils/create_skip_signatures.pl
index c311c6e77..4640875a4 100644
--- a/utils/create_skip_signatures.pl
+++ b/utils/create_skip_signatures.pl
@@ -66,8 +66,17 @@ while (<>)
 {
 	#print "XXX 0 $_";
 
+	# type signature
+	if ( /^DROP TYPE IF EXISTS\s\s*([^\s]*)/ )
+	{
+		my $t = lc($1);
+		$t =~ s/topology\.//g;
+		print "COMMENT TYPE $t\n";
+		print "TYPE $t\n";
+	}
+
 	# Function signature
-	if ( /^DROP FUNCTION IF EXISTS/ )
+	elsif ( /^DROP FUNCTION IF EXISTS/ )
 	{
 		my $origline = $_;
 		my $line = $origline;
diff --git a/utils/postgis_restore.pl.in b/utils/postgis_restore.pl.in
index c52ca9a01..eb60d3976 100644
--- a/utils/postgis_restore.pl.in
+++ b/utils/postgis_restore.pl.in
@@ -783,21 +783,6 @@ COMMENT FUNCTION st_worldtorastercoord(rast raster, pt geometry, OUT columnx int
 COMMENT FUNCTION updaterastersrid(schema_name name, table_name name, column_name name, new_srid integer)
 COMMENT FUNCTION updaterastersrid(table_name name, column_name name, new_srid integer)
 COMMENT SCHEMA topology
-COMMENT TYPE addbandarg
-COMMENT TYPE box2d
-COMMENT TYPE box3d
-COMMENT TYPE geography
-COMMENT TYPE geometry
-COMMENT TYPE geometry_dump
-COMMENT TYPE geomval
-COMMENT TYPE getfaceedges_returntype
-COMMENT TYPE rastbandarg
-COMMENT TYPE raster
-COMMENT TYPE reclassarg
-COMMENT TYPE summarystats
-COMMENT TYPE topogeometry
-COMMENT TYPE unionarg
-COMMENT TYPE validatetopology_returntype
 CONSTRAINT layer layer_pkey
 CONSTRAINT layer layer_schema_name_table_name_feature_column_key
 CONSTRAINT spatial_ref_sys spatial_ref_sys_pkey
@@ -1022,27 +1007,6 @@ TABLE layer
 TABLE spatial_ref_sys
 TABLE topology
 TRIGGER layer layer_integrity_checks
-TYPE addbandarg
-TYPE agg_count
-TYPE agg_samealignment
-TYPE box2d
-TYPE box2df
-TYPE box3d
-TYPE geography
-TYPE geometry
-TYPE geometry_dump
-TYPE geomval
-TYPE getfaceedges_returntype
-TYPE gidx
-TYPE rastbandarg
-TYPE raster
-TYPE reclassarg
-TYPE spheroid
-TYPE summarystats
-TYPE topogeometry
-TYPE unionarg
-TYPE validatetopology_returntype
-TYPE valid_detail
 VIEW geography_columns
 VIEW geometry_columns
 VIEW raster_columns

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

Summary of changes:
 utils/create_skip_signatures.pl | 11 ++++++++++-
 utils/postgis_restore.pl.in     | 36 ------------------------------------
 2 files changed, 10 insertions(+), 37 deletions(-)


hooks/post-receive
-- 
PostGIS