Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text() - Mailing list pgsql-admin

From Wells Oliver
Subject Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
Date
Msg-id CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com
Whole thread Raw
Responses Re: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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?


--

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Dropping functions from pg_proc table w/ querry
Next
From: Ian Barwick
Date:
Subject: Re: Dropping functions from pg_proc table w/ querry