Using regprocedure blocks pg_upgrade from doing a major PostgreSQL upgrade #6935
Description
timescaledb/sql/pre_install/tables.sql
Line 354 in f7255f0
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