[postgis-tickets] [PostGIS] #2823: [raster] upgrade drops privileges on the raster_columns view

[PostGIS]

#2823: [raster] upgrade drops privileges on the raster_columns view
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  dustymugs    
     Type:  defect    |      Status:  new          
 Priority:  critical  |   Milestone:  PostGIS 2.2.0
Component:  raster    |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
Changes (by robe):

  * milestone:  => PostGIS 2.2.0


Comment:

 strk,

 The more global issue is the GRANT statements in the full scripts are
 being stripped presumably by our upgrade script generator so we should
 have this issue anytime we drop a view.  Can we just always include the
 GRANTS? I don't think there is a case where applying grants more than once
 is an issue so we can simply just always include it. That will fix this
 issue and the future cases where we need to drop views.

 I tried running this with my 2.1.3 to 2.1.3next and don't see the issue
 there.  I also don't see a DROP VIEW raster_columns in the 2.1.3 upgrade
 scripts, so  this was added in 2.2 to add a new column.  If we add the
 column at the end, we don't even need to drop.  Only need to drop if we
 are changing column defs or adding a column in between others which we
 should probably avoid.

 I thought our upgrade scripts now handle view changes no?  So we shouldn't
 even need to put a drop in the rtpostgis_upgrade_cleanup even if we really
 needed to drop a view.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2823#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.