Re: pg_upgrade does not upgrade pg_stat_statements properly

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: pg_upgrade does not upgrade pg_stat_statements properly
Дата
Msg-id CADK3HHKz4ruqmqiph2cLvg53AibAPsEyen4uDXe1h5bu-nwWjg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade does not upgrade pg_stat_statements properly  (Julien Rouhaud <rjuju123@gmail.com>)
Ответы Re: pg_upgrade does not upgrade pg_stat_statements properly
Список pgsql-hackers
Дерево обсуждения


On Fri, 30 Jul 2021 at 06:39, Julien Rouhaud <rjuju123@gmail.com> wrote:
On Fri, Jul 30, 2021 at 06:03:50AM -0400, Dave Cramer wrote:
>
> What would happen if subsequent to the upgrade "ALTER EXTENSION UPGRADE"
> was executed ?

If the extension was already up to date on the source cluster then obviously
nothing.

Otherwise, the extension would be updated.  But unless I'm willing (and
remember) to copy/paste until the end of time an anonymous block code that
checks the current server version to see if the wrapper function needs to be
overwritten then nothing will happen either as far as this function is
concerned.

Well I think that's on the extension author to fix. There's only so much pg_upgrade can do here. 
It seems reasonable that upgrading the extension should upgrade the extension to the latest version.

Dave

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: pg_upgrade does not upgrade pg_stat_statements properly
Следующее
От: Lætitia Avrot
Дата:
Сообщение: Re: pg_dump new feature: exporting functions only. Bad or good idea ?