[postgis-devel] [PostGIS] #1365: postgis_upgrade_20_minor.sql is broken

[PostGIS]

#1365: postgis_upgrade_20_minor.sql is broken
----------------------+-----------------------------------------------------
 Reporter:  robe      |       Owner:  strk         
     Type:  defect    |      Status:  assigned     
 Priority:  critical  |   Milestone:  PostGIS 2.0.0
Component:  postgis   |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
Changes (by strk):

  * owner:  pramsey => strk
  * status:  new => assigned


Comment:

 The structure changed adding:

 {{{
   check (srid > 0 and srid < 999000)
 }}}

 The check would be safer to add after making sure nothing breaks it.
 Speaking of which, the new_postgis_upgrade script defines the table using
 the new definition and would thus fail loading data with SRID values >=
 999000

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