Opened 12 years ago
Closed 9 years ago
#2138 closed defect (wontfix)
When drop postgis_topology extension doesn't drop topology schema
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 2.2.0 |
Component: | topology | Version: | 2.0.x |
Keywords: | Cc: |
Description
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.
Change History (7)
comment:1 by , 11 years ago
Milestone: | PostGIS 2.0.4 → PostGIS 2.2.0 |
---|
comment:2 by , 11 years ago
comment:3 by , 11 years ago
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.
comment:4 by , 11 years ago
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
comment:5 by , 10 years ago
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)
comment:6 by , 10 years ago
Robe, see how you like r13171 (in trunk) -- not sure it'd be worth backporting, not being a core issue
comment:7 by , 9 years ago
Resolution: | → wontfix |
---|---|
Status: | new → closed |
good enough. I'm fine with it not working for install which was the underlying issue I complained about.
Does PostgreSQL provide any hook on DROP EXTENSION ?