[postgis-devel] [PostGIS] #1325: topology_upgrade_20_minor.sql is harmful

[PostGIS]

#1325: topology_upgrade_20_minor.sql is harmful
----------------------+-----------------------------------------------------
 Reporter:  strk      |       Owner:  robe         
     Type:  defect    |      Status:  new          
 Priority:  high      |   Milestone:  PostGIS 2.0.0
Component:  topology  |     Version:  trunk        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Right after sourcing topology_upgrade_20_minor.sql, my
 topology.CreateTopology() doesn't work anymore.

 See this session:
 {{{
 strk=# select droptopology('tt');
 Topology 'tt' dropped
 strk=# select createtopology('tt');
 ERROR:  schema "tt" does not exist
 }}}

 Sourcing topology.sql fixes things again:
 {{{
 strk=# select droptopology('tt');
 Topology 'tt' dropped
 strk=# select createtopology('tt');
 2086
 }}}

 Sourcing topology_upgrade_20_minor.sql breaks again as in the first
 example.

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