[Enhancement]: Remove useless metadata table _timescaledb_catalog.continuous_aggs_bucket_function

[fabriziomello]

What type of enhancement is this?

Tech debt reduction

What subsystems and features will be improved?

Continuous aggregate

What does the enhancement do?

Remove useless metadata table _timescaledb_catalog.continuous_aggs_bucket_function. This table is not necessary anymore because we already refactored the current code to get the bucket function Oid based on the query tree stored on Postgres metadata (#7042).

Implementation challenges

No response

[K-Kumar-01]

@fabriziomello
Can I work on the issue if no one else has started working on it?

[philkra]

@K-Kumar-01 yes, feel free to submit a PR. Thank you

[fabriziomello]

@K-Kumar-01 yes, feel free to submit a PR. Thank you

I've sent an old PR I started months ago: #7532

It is in WIP stage and I noticed a small bug and sent another to fix before continue on it: #7533.

But if you want to continue this work I'll be more than happy to guide you.

[K-Kumar-01]

Hi @philkra
Thanks for replying.
@fabriziomello
I will look at your PRs today starting 7533 followed by 7532. I will post my insights here as soon as possible.
Thank you for your help.