Re: array_cat anycompatible change is breaking xversion upgrade tests - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: array_cat anycompatible change is breaking xversion upgrade tests
Date
Msg-id CB500650-3F3C-45A5-A06C-96621364AF7E@yandex-team.ru
Whole thread Raw
In response to array_cat anycompatible change is breaking xversion upgrade tests  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: array_cat anycompatible change is breaking xversion upgrade tests
Re: array_cat anycompatible change is breaking xversion upgrade tests
List pgsql-hackers
Hi everyone!

Sorry for bumping old thread.

> On 25 May 2021, at 21:14, Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> Such aggregate functions should be dropped before upgrade/restore and then
> re-created afterwards using the "anycompatible" functions.  The affected
> functions are: array_append, array_prepend, array_cat, array_position,
> array_positions, array_remove, array_replace, and width_bucket.

We've just stumbled upon the problem in our service. Would it be backpatchable to add this check to pg_upgrade?

I want to check something like

select * from pg_aggregate join pg_proc on (aggtransfn = pg_proc.oid)
where proname in ('array_append', 'array_prepend','array_cat', 'array_position','array_positions', 'array_remove',
'array_replace','width_bucket') ; 

select * from pg_operator join pg_proc on (oprcode = pg_proc.oid)
where proname in ('array_append', 'array_prepend','array_cat', 'array_position','array_positions', 'array_remove',
'array_replace','width_bucket') and pg_operator.oid >= 16384; 

if pg_upgrade is executed with --check option.

Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: making relfilenodes 56 bits
Next
From: Peter Eisentraut
Date:
Subject: Re: Unify DLSUFFIX on Darwin