From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Struggling with 13->14 and anyarray -> anycompatiblearray
In-reply-to: 
 <CAOC+FBVs_AqBFY+0ExnHsnA9BDRwuOsHpxRL+rLuCsuxP5t5Jg@mail.gmail.com>
References: 
 <CAOC+FBWmZ0Btu5bqkLy5pp82JVtE6z677uCjkzRnkJMZzY6mtQ@mail.gmail.com>
 <2475533.1667589169@sss.pgh.pa.us>
 <CAOC+FBVs_AqBFY+0ExnHsnA9BDRwuOsHpxRL+rLuCsuxP5t5Jg@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Fri, 04 Nov 2022 13:51:59 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2490999.1667597489.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Fri, 04 Nov 2022 17:31:29 -0400
Message-ID: <2491000.1667597489@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2491000.1667597489%40sss.pgh.pa.us>
Precedence: bulk

Wells Oliver <wells.oliver@gmail.com> writes:
> Thanks. This seems to return aggregates where array_append is used with
> anyarray, but I now see aggregates where e.g. array_cat is used with
> anyarray. Is there some way to generally query aggregates where any arra=
y
> function might be looking for anyarray and need to be dropped/re-created
> with anycompatiblearray?

Looking for aggtranstype =3D 'anyarray'::regtype would give you a hit list=
,
but beware that not every one of those was changed.  Looking at HEAD,
I see

postgres=3D# select aggfnoid::regprocedure from pg_aggregate where aggtran=
stype =3D 'anyarray'::regtype;
   aggfnoid    =

---------------
 max(anyarray)
 min(anyarray)
(2 rows)

so you'd want to exclude those.  (I guess just skipping ones with oid <
9999 would be enough to skip built-ins.)

			regards, tom lane