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@xxxxxxxxxx> https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.
