[postgis-devel] [PostGIS] #1495: PostGIS micro upgrade script doesn't update spatial_ref_sys

[PostGIS]

#1495: PostGIS micro upgrade script doesn't update spatial_ref_sys
---------------------+------------------------------------------------------
 Reporter:  robe     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 During minor/micro upgrades our scripts do not update spatial_ref_sys.  We
 probably should roll in fixed / added entries or reload just those that
 are in our list

 with a

 {{{

 delete from spatial_ref_sys where srid IN(SELECT srid FROM
 postgis_spatial_ref_sys_official)

 INSERT INTO spatial_ref_sys(...) SELECT ** FROM our new_list;
 }}}

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