Struggling with 13->14 and anyarray -> anycompatiblearray

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Struggling with 13->14 and anyarray -> anycompatiblearray
Date: 2022-11-04 18:47:41
Message-ID: CAOC+FBWmZ0Btu5bqkLy5pp82JVtE6z677uCjkzRnkJMZzY6mtQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-11-04 19:12:49 Re: Struggling with 13->14 and anyarray -> anycompatiblearray
Previous Message Ron 2022-11-04 01:43:56 Re: Reg help on PGPOOL & Watchdog