Postgres Pro
Downloads
Home   >   mailing lists

Struggling with 13->14 and anyarray -> anycompatiblearray - Mailing list pgsql-admin

From Wells Oliver
Subject Struggling with 13->14 and anyarray -> anycompatiblearray
Date
Msg-id CAOC+FBWmZ0Btu5bqkLy5pp82JVtE6z677uCjkzRnkJMZzY6mtQ@mail.gmail.com
Whole thread Raw
Responses Re: Struggling with 13->14 and anyarray -> anycompatiblearray
List pgsql-admin
Tree view
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 by date:

Previous
From: Ron
Date:
Subject: Re: Reg help on PGPOOL & Watchdog
Next
From: Tom Lane
Date:
Subject: Re: Struggling with 13->14 and anyarray -> anycompatiblearray