Ticket #1746 (closed defect: fixed)
Upgrade scripts are not installing all functions
|Reported by:||robe||Owned by:||strk|
I haven't bothered ticketing this because a long time ago it wasn't possible when I first tried it.
If I start with a beta install and upgrade to say rc2 and then I move my postgis extension to a new schema. There are two functions left behind.
Steps to create.
-- install beta2 or-- CREATE EXTENSION postgis ; -- install rc1 or rc2 -- ALTER EXTENSION postgis UPDATE TO "2.0.0rc2"; CREATE SCHEMA postgis; ALTER EXTENSION postgis SET SCHEMA postgis;
When I upgrade one that I've been upgrading for a while I actually have 6 functions left behind in public.
st_dump, st_intersection(postgis.raster....) (4 permutations of this), st_isvaliddetail(postgis.geometry).
These might be signature changes we didn't drop so may be a sign of us not populating the drop scripts for these.