[postgis-devel] [PostGIS] #1619: Extensions mark user editable objects

[PostGIS]

#1619: Extensions mark user editable objects
-----------------------------------+----------------------------------------
 Reporter:  robe                   |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  blocker                |   Milestone:  PostGIS 2.0.0
Component:  build/upgrade/install  |     Version:  trunk        
 Keywords:                         |  
-----------------------------------+----------------------------------------
 Putting this in before I forget.  Right now none of the tables in the
 postgis and postgis_topology extensions are marked as user editable.

 What does this mean.  It means they don't get backed up which is bad.

 We need to do this before release.  I assume the following need to be
 marked as user editable. When marked as such just the data is backed up
 (not the structure).

 spatial_ref_sys

 topology.layer

 topology.topology

 Any others anyone can think of?  I was hoping we could add a bit to
 spatial_ref_sys that says user defined or something because extensions
 does give you the provision of only backing up entries that fit a certain
 condition.  Which means if a person does a hard upgrade, they'll get all
 our corrected entries when they restore and their custom ones and for
 minor upgrades we can delete all records not marked as user defined and
 reinsert all of ours.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1619>
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.