Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()

Wells Oliver <[email protected]> Tue, 29 Oct 2019 20:17:40 -0700
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com>
I have some implicit casts such as real to text where they depend on the
function pg_catalog.text(real) which seems to no longer exist in 12. The
pg_upgrade failure says:

Command was: CREATE CAST (real AS "text") WITH FUNCTION
"pg_catalog"."text"(real) AS IMPLICIT;

Should I just DROP CAST (real as text) or is there a better solution?


-- 
Wells Oliver
[email protected] <[email protected]>