On Wed, Nov 10, 2021 at 12:30:37PM +0500, Дмитрий Иванов wrote:
> Hello!
> E.1.2 Migration to Version 14
> array_append(), array_prepend(), array_cat(), array_position(),
> array_positions(), array_remove(), array_replace(), and width_bucket()
>
> Is this a complete list of functions? Or you need to remove all functions:
> Table 9.52. Array Functions
>
> Do the functions need to be deleted and restored, or can they be recreated?
> I have a lot of them and they are called from other functions:
>
> Uchet=# SELECT COUNT(pg_proc.proname) AS "COUNT"
> Uchet-# FROM pg_proc
> Uchet-# WHERE pg_proc.prosrc ~~ '%array%'::text AND pg_proc.pronamespace =
> 16443::oid;
> COUNT
> -------
> 89
> (1 row)
> Trying to estimate labor costs and migration opportunities.
> Thanks!
Uh, I think they can just be recreated on the new server. I think we
suggested delete then create so that the functions would not be called
accidentally on the new server before being recreated.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.