Using `regprocedure` blocks `pg_upgrade` from doing a major PostgreSQL upgrade

[feikesteenbergen]

timescaledb/sql/pre_install/tables.sql

Line 354 in f7255f0

bucket_func regprocedure NOT NULL,

In the docs:

pg_upgrade does not support upgrading of databases containing table columns using these reg* OID-referencing system data types:

regcollation
regconfig
regdictionary
regnamespace
regoper
regoperator
regproc
regprocedure

(regclass, regrole, and regtype can be upgraded.)

https://www.postgresql.org/docs/current/pgupgrade.html

This in turn causes major upgrades to fail with this error message:

Checking for reg* data types in user tables                   fatal
Your installation contains one of the reg* data types in user tables.
These data types reference system OIDs that are not preserved by
pg_upgrade, so this cluster cannot currently be upgraded.  You can
drop the problem columns and restart the upgrade.
A list of the problem columns is in the file:
/home/postgres/pgdata/data.16/pg_upgrade_output.d/20240518T141654.340/tables_using_reg.txt