From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
Date: Wed, 30 Oct 2019 01:22:13 -0400
Message-ID: <28392.1572412933@sss.pgh.pa.us> (raw)
In-Reply-To: <CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com>
References: <CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com>
Wells Oliver <wells.oliver@gmail.com> writes:
> 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;
Hm, there wasn't any such function in 9.6 either, so I suspect you've
forgotten some critical details about how these casts got created.
But anyway, if you really want that behavior, creating the cast
"WITH INOUT" is probably the best way to do it.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, wells.oliver@gmail.com
Subject: Re: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
In-Reply-To: <28392.1572412933@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox