[postgis-tickets] [SCM] PostGIS branch stable-3.2 updated. 3.2.2-12-g89d8463bb

git at osgeo.org git at osgeo.org
Fri Aug 12 00:13:03 PDT 2022


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, stable-3.2 has been updated
       via  89d8463bb64694f939586b05e4f2be0f4cc192d4 (commit)
      from  b1cdf7485bdb337bb22d78347eb90c73ded58408 (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 89d8463bb64694f939586b05e4f2be0f4cc192d4
Author: Sandro Santilli <strk at kbt.io>
Date:   Fri Aug 12 09:12:49 2022 +0200

    Backport upgrade hooks from master branch

diff --git a/regress/hooks/hook-after-upgrade.sql b/regress/hooks/hook-after-upgrade.sql
index 0ca56e675..7f95eb762 100644
--- a/regress/hooks/hook-after-upgrade.sql
+++ b/regress/hooks/hook-after-upgrade.sql
@@ -5,6 +5,7 @@ DROP VIEW IF EXISTS upgrade_view_test_union;
 DROP VIEW IF EXISTS upgrade_view_test_force_dims;
 DROP VIEW IF EXISTS upgrade_view_test_askml;
 DROP VIEW IF EXISTS upgrade_view_test_dwithin;
+DROP VIEW IF EXISTS upgrade_view_test_clusterkmeans;
 DROP TABLE upgrade_test;
 
 -- Drop functions deprecated on upgrade
@@ -21,3 +22,4 @@ DROP FUNCTION IF EXISTS st_askml_deprecated_by_postgis_200(geometry,integer);
 DROP FUNCTION IF EXISTS st_askml_deprecated_by_postgis_200(geography,integer);
 DROP FUNCTION IF EXISTS st_dwithin_deprecated_by_postgis_300(geography,geography,float8);
 DROP FUNCTION IF EXISTS st_dwithin_deprecated_by_postgis_300(text,text,float8);
+DROP FUNCTION IF EXISTS st_clusterkmeans_deprecated_by_postgis_302(geometry,integer);
diff --git a/regress/hooks/hook-before-upgrade.sql b/regress/hooks/hook-before-upgrade.sql
index 7185b56bc..f15b71111 100644
--- a/regress/hooks/hook-before-upgrade.sql
+++ b/regress/hooks/hook-before-upgrade.sql
@@ -75,6 +75,13 @@ SELECT
 	ST_DWithin(g2, g2, 1) as geography_dwithin
 FROM upgrade_test;
 
+-- Add view using ST_ClusterKMeans windowing function
+-- NOTE: 3.2.0 changed it to add max_radius parameter
+CREATE VIEW upgrade_view_test_clusterkmeans AS
+SELECT
+	ST_ClusterKMeans(g1, 1) OVER ()
+FROM upgrade_test;
+
 -- Break probin of all postgis functions, as we expect
 -- the upgrade procedure to replace them all
 UPDATE pg_proc SET probin = probin || '-uninstalled'

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

Summary of changes:
 regress/hooks/hook-after-upgrade.sql  | 2 ++
 regress/hooks/hook-before-upgrade.sql | 7 +++++++
 2 files changed, 9 insertions(+)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list