[postgis-tickets] [SCM] PostGIS branch main updated. 3.1.0rc1-352-ge5054a9

[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, main has been updated
       via  e5054a9dc94ad83e53f7ac2504438f2cad082149 (commit)
      from  fba0330289c7ad2ed3cc5642f259940c59beda6b (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 e5054a9dc94ad83e53f7ac2504438f2cad082149
Author: Sandro Santilli <strk at kbt.io>
Date:   Thu Jul 15 15:26:21 2021 +0200

    Update topology.topology srids < 0 on upgrade
    
    Closes #3192

diff --git a/topology/topology_drop_after.sql.in b/topology/topology_drop_after.sql.in
index a7146a2..d1bc7cb 100644
--- a/topology/topology_drop_after.sql.in
+++ b/topology/topology_drop_after.sql.in
@@ -16,3 +16,19 @@
 -- This allows us to CREATE OR REPLACE those in general topology.sql
 -- without dropping them.
 
+DO $BODY$
+DECLARE
+  rec RECORD;
+BEGIN
+  FOR rec IN
+    WITH updated AS (
+      UPDATE topology.topology SET SRID=0 WHERE SRID<0
+      RETURNING *
+    )
+    SELECT * FROM updated
+  LOOP
+    -- NOTE: these notices will not be shown during extension upgrade
+    RAISE NOTICE 'Topology % had SRID<0, updated to the officially unknown SRID value 0', rec.name;
+  END LOOP;
+END;
+$BODY$ LANGUAGE 'plpgsql';

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

Summary of changes:
 topology/topology_drop_after.sql.in | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)


hooks/post-receive
-- 
PostGIS