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

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()
Дата
Msg-id CAOC+FBVkQG2PitVHU6Hjpfrjsdi3w3OywvXmT+d7FSN4eX2FHA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Upgrading from 9.6 to 12 and running into cast issues with pg_catalog.text()  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Dropping functions from pg_proc table w/ querry
Следующее
От: Ian Barwick
Дата:
Сообщение: Re: Dropping functions from pg_proc table w/ querry