[postgis-tickets] r15276 - PostGIS upgrade scripts missing GRANT for views

[Regina Obe]

Author: robe
Date: 2016-12-19 16:07:54 -0800 (Mon, 19 Dec 2016)
New Revision: 15276

Modified:
   trunk/utils/postgis_proc_upgrade.pl
Log:
PostGIS upgrade scripts missing GRANT for views
references #3680 for trunk (PostGIS 2.4)

Modified: trunk/utils/postgis_proc_upgrade.pl
===================================================================
--- trunk/utils/postgis_proc_upgrade.pl	2016-12-16 18:55:39 UTC (rev 15275)
+++ trunk/utils/postgis_proc_upgrade.pl	2016-12-20 00:07:54 UTC (rev 15276)
@@ -378,6 +378,17 @@
 			last if /\;\s*$/;
 		}
 	}
+	
+	# Always output grant permissions (see ticket #3680)
+	if ( /^grant select\s+(\S+)\s*/i )
+	{
+		print;
+		while(<INPUT>)
+		{
+			print;
+			last if /\;\s*$/;
+		}
+	}
 
 	# Always output create ore replace rule 
 	if ( /^create or replace rule\s+(\S+)\s*/i )