[postgis-tickets] [PostGIS] #3196: DropTopology can drop the topology extension

[PostGIS]

#3196: DropTopology can drop the topology extension
----------------------+---------------------------
 Reporter:  mwtoews   |      Owner:  strk
     Type:  defect    |     Status:  new
 Priority:  high      |  Milestone:  PostGIS 2.2.0
Component:  topology  |    Version:  trunk
 Keywords:            |
----------------------+---------------------------
 On a test database, try the following:
 {{{
 CREATE EXTENSION postgis_topology;
 SELECT topology.DropTopology('this does not exist');
 -- Topology 'this does not exist' dropped
 SELECT topology.DropTopology('topology');
 -- Topology 'topology' dropped
 }}}
 The first `DropTopology` on a non-existing topology shows a misleading
 message. Either the return value should indicate that the topology does
 not exist or an exception should be raised.

 The second `DropTopology` kills the topology extension with `DROP SCHEMA
 '||quote_ident(atopology)||' CASCADE`, which should have been avoided as
 `topology` does not have a `topoid`. This can be disastrous.

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