Upgrading Timescale extension from 2.8.1 to version 2.11.1 fails when the scripts are installed.

[expaso]

When these scripts are installed, the upgrade of the timescale extension fails with:

cannot drop _timescaledb_catalog.dimension_slice because it depends on function public.get_dimension_details(regclass)
Same error for the views: public.chunks_tstz and public.chunks_ts

This is rather nasty for me, since I don't know if users have timescaledb-extra's installed or not, and I do unsupervised upgrade.

For now, I drop these function if they exist before upgrade, but I found it worth mentioning because there may be more elegant solutions.

[xbarra]

since the PR was merged, can this issue be closed?

[expaso]

No unfortunately not.

I worked around the issue in a nasty way by dropping the objects prematurely before upgrading, which forces my user te reinstall the scripts afterwards.

But the rootcause still remains: Installing TimescaleDb-Extra's breaks the normal update procedure of TimescaleDb,
because your scripts depend on timesacle-db tables/views that could be dropped and recreated by the timescaledb updater.

Perhaps you could use something like Query-Language functions? (https://www.postgresql.org/docs/current/xfunc-sql.html)
That will prevent Postgres from tracking hard dependencies..
It won't work for your views, unless you base those views on Query Language functions...