[postgis-devel] [PostGIS] #1831: ability to separate user defined spatial_ref_sys from installed

[PostGIS]

#1831: ability to separate user defined spatial_ref_sys from installed
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.1.0
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by chodgson):

 I think I like (3). Has the best elements of the other options, and I
 can't really think of a drawback - except the "overhead" of the extra
 table, but if we accept that we need to store the information about where
 a spatial_ref_sys value came from somewhere, this is a pretty minimal and
 also fairly explicit and clear way to do it. The inheritance and DO
 INSTEAD trigger are a little bit of magic but there's no reason not to
 take advantage of the tools Postgres offers us.

 I think we need to have spatial_ref_sys inherit from
 custom_spatial_ref_sys though, right? So that the custom entries show up
 in the main table?

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