[postgis-tickets] [PostGIS] #4202: Topology extension upgrade from 2.1.9 to 3.0.0dev fails

[PostGIS]

#4202: Topology extension upgrade from 2.1.9 to 3.0.0dev fails
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  medium                 |  Milestone:  PostGIS 3.0.0
 Component:  build/upgrade/install  |    Version:  trunk
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by strk):

 The problem seems related to #2138 as the uninstall code in `run_test.pl`
 goes:
 {{{
     if ( $OPT_WITH_TOPO )
     {
         # NOTE: "manually" dropping topology schema as EXTENSION does not
         #       take care of that itself, see
         #       http://trac.osgeo.org/postgis/ticket/2138
         $cmd = "psql $psql_opts -c \"DROP EXTENSION postgis_topology; DROP
 SCHEMA topology;\" $DB >> $REGRESS_LOG 2>&1";
         $rv = system($cmd);
           $ok = 0 if $rv;
     }
 }}}

 I guess the `DROP SCHEMA topology` is checked _before_ the `DROP
 EXTENSION` takes effect (within same transaction) thus the problem.

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