Struggling with 13->14 and anyarray -> anycompatiblearray

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема Struggling with 13->14 and anyarray -> anycompatiblearray
Дата
Msg-id CAOC+FBWmZ0Btu5bqkLy5pp82JVtE6z677uCjkzRnkJMZzY6mtQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Struggling with 13->14 and anyarray -> anycompatiblearray  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
I've inherited a DB with a lot of legacy functions and aggregates that have an SFUNC of array_append and an STYPE of anyarray.

Upgrading to 14 fails as these need an STYPE of anycompatiblearray.

I'm only able to discover these by failing an upgrade and seeing the log. Is there some way I can query for these aggregates/functions and see how many I need to drop and have available to replace after a successful upgrade?

--

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Reg help on PGPOOL & Watchdog
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Struggling with 13->14 and anyarray -> anycompatiblearray