[postgis-tickets] [PostGIS] #2147: error when updating postgis_topology extension

[PostGIS]

#2147: error when updating postgis_topology extension
-----------------------------------+----------------------------------------
 Reporter:  kyngchaos              |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  critical               |   Milestone:  PostGIS 2.0.3
Component:  build/upgrade/install  |     Version:  2.0.x        
 Keywords:                         |  
-----------------------------------+----------------------------------------

Comment(by kyngchaos):

 they are different - extra stuff at the begin and end of the update
 version.

 During compilation, I see this to create the update sql:

 {{{
 sed -e '/^\(CREATE\|ALTER\)
 \(CAST\|TYPE\|TABLE\|SCHEMA\|DOMAIN\|TRIGGER\).*;/d' \
                  -e '/^\(CREATE\|ALTER\)
 \(CAST\|TYPE\|TABLE\|SCHEMA\|DOMAIN\|TRIGGER\)/,/\;/d' \
                  sql_bits/topology.sql > sql/topology_upgrade_minor.sql
 }}}

 OS X has BSD sed... I tried the sed command in a Terminal (minus the
 escaping), same results.  I added the BSD -E flag for extended (modern)
 REs and that looks like it removed the CREATEs and other items that don't
 check for existence first. I guess BSD sed does old BREs by default.

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