When drop postgis_topology extension doesn't drop topology schema

[robe]

This is only an extension issue since when people uninstall topology if they used the scripts, they'd probably just drop cascade topology.

Then again I guess it might still be stuck in the search_path which could cause other issues.

[strk]

Does PostgreSQL provide any hook on DROP EXTENSION ?

[robe]

Hmm I don't think so. Closest thing I can think of is 9.3 event triggers. Then we could define a trigger on drop extension event. ​http://www.postgresql.org/docs/9.3/interactive/event-trigger-matrix.html That sounds kind of scary though since it would check whenever any extension is dropped and not sure what happens if you have an event trigger as part of an extension and its triggering would drop itself. We might have to push this to PostGIS Future and raise as a feature request upstream so we can do something about it.

[robe]

I think fails our regression in #2730 as a result.

I was hoping I could get away with doing this

ALTER EXTENSION postgis_topology ADD SCHEMA topology;

but drats I get this error

ERROR:  cannot add schema "topology" to extension "postgis_topology" because the schema contains the extension

[strk]

if the problem is just with the testcase, we could make the "cleanup" method of the script take care of dropping the topology schema explicitly (with no CASCADE, maybe)

[strk]

Robe, see how you like r13171 (in trunk) — not sure it'd be worth backporting, not being a core issue

[robe]

good enough. I'm fine with it not working for install which was the underlying issue I complained about.