[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):

 Hmm, I was going to try a quick patch myself so I can package a fixed OS X
 installer, and I see that the postgis extension update script has some
 non-POSIX sed REs also.  But Postgres didn't complain about this one, the
 postgis extension update ran without error:

 {{{
 sql_bits/postgis_upgrade_minor.sql:
 ../../postgis/postgis_upgrade_20_minor.sql
                  sed -e 's/BEGIN;//g' -e 's/COMMIT;//g' \
                  -e '/^\(DROP\|CREATE\) \(CAST\).*;/d' \
 ...
 }}}

 for (one example):

 {{{
 DROP CAST IF EXISTS (geometry AS geometry);
 CREATE CAST (geometry AS geometry) WITH FUNCTION geometry(geometry,
 integer, boolean) AS IMPLICIT;
 }}}

 probably because it's dropping the cast before creating it.

 This one uses sed to strip them out in both the extension and non-
 extension update scripts.

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