From 4701f37c52389cca3150f794637fb0c2bc301e91 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 20 Dec 2016 00:07:54 +0000 Subject: [PATCH] PostGIS upgrade scripts missing GRANT for views references #3680 for trunk (PostGIS 2.4) git-svn-id: http://svn.osgeo.org/postgis/trunk@15276 b70326c6-7e19-0410-871a-916f4a2858ee --- utils/postgis_proc_upgrade.pl | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/utils/postgis_proc_upgrade.pl b/utils/postgis_proc_upgrade.pl index 0425b0168..ebf7cf61f 100755 --- a/utils/postgis_proc_upgrade.pl +++ b/utils/postgis_proc_upgrade.pl @@ -378,6 +378,17 @@ EOF last if /\;\s*$/; } } + + # Always output grant permissions (see ticket #3680) + if ( /^grant select\s+(\S+)\s*/i ) + { + print; + while() + { + print; + last if /\;\s*$/; + } + } # Always output create ore replace rule if ( /^create or replace rule\s+(\S+)\s*/i ) -- 2.40.0