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]>