E.1.2. Migration to Version 14

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: E.1.2. Migration to Version 14
Date: 2021-11-10 07:30:37
Message-ID: CAPL5KHrASvz46u4rKwiZ4Ui3J9sUnEkxc0H0QMfz4o0bFAevNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!
E.1.2 Migration to Version 14
<https://www.postgresql.org/docs/14/release-14.html#id-1.11.6.5.4>
array_append() <https://www.postgresql.org/docs/14/functions-array.html>,
array_prepend(), array_cat(), array_position(), array_positions(),
array_remove(), array_replace(), and width_bucket()
<https://www.postgresql.org/docs/14/functions-math.html>

Is this a complete list of functions? Or you need to remove all functions:
Table 9.52. Array Functions
<https://www.postgresql.org/docs/14/functions-array.html>

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2021-11-10 07:53:44 Re: Understanding the differences between Temporal tables, CDC and Time Series.
Previous Message SQL Padawan 2021-11-10 06:43:01 Understanding the differences between Temporal tables, CDC and Time Series.