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

[Regina Obe]

Author: robe
Date: 2016-12-19 19:22:46 -0800 (Mon, 19 Dec 2016)
New Revision: 15278

Modified:
   branches/2.3/utils/postgis_proc_upgrade.pl
Log:
PostGIS upgrade scripts missing GRANT for views
references #3680 for PostGIS 2.3

Modified: branches/2.3/utils/postgis_proc_upgrade.pl
===================================================================
--- branches/2.3/utils/postgis_proc_upgrade.pl	2016-12-20 00:08:32 UTC (rev 15277)
+++ branches/2.3/utils/postgis_proc_upgrade.pl	2016-12-20 03:22:46 UTC (rev 15278)
@@ -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 )