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

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
Date: 2019-10-30 03:17:40
Message-ID: CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Barwick 2019-10-30 03:26:46 Re: Dropping functions from pg_proc table w/ querry
Previous Message Wells Oliver 2019-10-30 03:05:10 Dropping functions from pg_proc table w/ querry