[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:            |  
----------------------+-----------------------------------------------------

Comment(by strk):

 I guess the issue on upgrade is that someone may not want the upgrade to
 change permissions that were manually changed to something else. Hard to
 detect as a condition as it would imply knowing the system-defined
 permissions as of the version it's been upgraded from.

 Not dropping is surely a good idea, generally. But there will still be
 cases in which you'll need to. In those cases, the upgrade script should
 probably note the permissions before the drop and re-set them after the
 creation. Beside augmented complexity, this behavior would make it
 impossible for an upgrade to change default permissions. The only way to
 not have that problem would be for permissions to not be part of the
 install scripts at all, but maybe have a function to "set default
 permissions"...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2823#comment:10>
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.