[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-290-g910dfdc15

[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  910dfdc155df7ee578f2520ff55b684c200dba0b (commit)
      from  1f3fc078faa66ed6596a5715883fe77764ae071f (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 910dfdc155df7ee578f2520ff55b684c200dba0b
Author: Sandro Santilli <strk at kbt.io>
Date:   Fri Jul 29 11:19:29 2022 +0200

    Improve security definer test
    
    Change security of postgis function before ugprade test

diff --git a/regress/hooks/hook-before-upgrade.sql b/regress/hooks/hook-before-upgrade.sql
index f15b71111..e5a78de74 100644
--- a/regress/hooks/hook-before-upgrade.sql
+++ b/regress/hooks/hook-before-upgrade.sql
@@ -86,3 +86,11 @@ FROM upgrade_test;
 -- the upgrade procedure to replace them all
 UPDATE pg_proc SET probin = probin || '-uninstalled'
 WHERE probin like '%postgis%';
+
+-- Change SECURITY of postgis_version() to DEFINER
+-- to verify the bit is reset upon upgrade
+--
+-- NOTE: we pick postgis_version as one of the oldest
+--       function names
+--
+ALTER FUNCTION postgis_version() SECURITY DEFINER;

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

Summary of changes:
 regress/hooks/hook-before-upgrade.sql | 8 ++++++++
 1 file changed, 8 insertions(+)


hooks/post-receive
-- 
PostGIS