[postgis-tickets] [PostGIS] #2223: Rules on geometry_columns make noisy backup/restore

[PostGIS]

#2223: Rules on geometry_columns make noisy backup/restore
-----------------------------------+----------------------------------------
 Reporter:  pramsey                |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.0.4
Component:  build/upgrade/install  |     Version:  2.0.x        
 Keywords:  rules                  |  
-----------------------------------+----------------------------------------

Comment(by robe):

 Hmm I'll have to check that out.  You sure geography_columns was not
 recreated.  That is a view too.

 Regarding the permissions issue which version of PostGIS are you running?
 I think in 2.0.3 (sorry my memory is going, might be 2.0.4SVN not
 released), I added to the script logic to explicit set views permissions
 to allow public read.

 I suspect that since the views etc are not part of backup, that they are
 recreated by CREATE EXTENSION that is why no permissions are being backed
 up, but with the newest version of 2.0 and also upcoming 2.1, the
 permissions should be fine.  So what I am saying is the permission issue
 may already be fixed.

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