[postgis-devel] [PostGIS] #1505: Deal with database dumps containing geometries with SRID > MAX_SRID

[PostGIS]

#1505: Deal with database dumps containing geometries with SRID > MAX_SRID
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  high     |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 Ok, here's the new plan.

  1) We drop the 999000 limit in spatial_ref_sys and transform that to a
 WARNING raising trigger
  2) We clamp any value > the typmod max into the "reserved range"
 (currently 999000..999999)

 That way geometry values with out-of-range srids would be dragged into the
 "reserved range" thus being kind of unusable for reprojection purposes but
 identifiable by looking at the postgis_restore.pl log.

 Redefining ranges would still be useful.

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