Re: E.1.2. Migration to Version 14

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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.