pg_upgrade (12->14) fails on aggregate

Поиск
Список
Период
Сортировка
От Petr Vejsada
Тема pg_upgrade (12->14) fails on aggregate
Дата
Msg-id 3383880.QJadu78ljV@vejsadalnx
обсуждение исходный текст
Ответы Re: pg_upgrade (12->14) fails on aggregate  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Hi Team,

we experienced pg_upgrade failing when attempted to upgrade from 12.10 to 14.2 
(on AWS RDS)

We had this aggregate:

CREATE AGGREGATE public.array_accum(anyelement) ( SFUNC = array_append, STYPE 
= anyarray, INITCOND = '{}');

Syntax in version 14 is changed (we didn't try to run version 13)

We solved it (in our case) dropping the aggregate before upgrade and re-create 
in using new syntax in V14:

CREATE AGGREGATE public.array_accum(anycompatible) ( SFUNC = array_append, 
STYPE = anycompatiblearray, INITCOND = '{}');

but pg_upgrade shouldn't fail on this.

I hope it can help to improve pg_upgrade process.

Thanks.

--
Best
Petr





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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Implicitly created operator family not listed by pg_event_trigger_ddl_commands
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_upgrade (12->14) fails on aggregate