[Bug]: Updating extension from 2.11.2 to 2.12.1 fails

[aaronovz1]

What type of bug is this?

Other

What subsystems and features are affected?

Other

What happened?

Any suggestions on how to safely upgrade the extension?

tsdb=# ALTER EXTENSION timescaledb UPDATE;
ERROR:  cannot drop view timescaledb_information.hypertables because other objects depend on it
DETAIL:  view public.table_stats depends on view timescaledb_information.hypertables
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

TimescaleDB version affected

2.11.2

PostgreSQL version used

14

What operating system did you use?

Ubuntu

What installation method did you use?

Deb/Apt

What platform did you run on?

Amazon Web Services (AWS)

Relevant log output and stack trace

No response

How can we reproduce the bug?

Run `ALTER EXTENSION timescaledb UPDATE;` on version 2.11.2.

[konskov]

hello @aaronovz1, thanks for reaching out. Could you try dropping the dependent view table_stats before the upgrade and recreating it after it completes? You are getting this error specifically because of the dependency.

[aaronovz1]

Hey @konskov that looks to have done the trick! Thanks