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!
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. |