Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore
Дата
Msg-id CAKFQuwYbqurFWg0W8mqBsHLsCyxZAZqBdV0q-beEFTbeBNhO2A@mail.gmail.com
обсуждение исходный текст
Ответ на Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore
Список pgsql-bugs
Дерево обсуждения
On Mon, Apr 15, 2024 at 8:15 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
tl/dr - alter extension ... set schema ...  needs to update pg_extension.extnamespace if the named schema matches the current value in the control file.  Otherwise, extension authors can and have introduced a dump/restore failure mode that the DBA can only fix via direct catalog manipulation.


Tom's recent bug regarding alter extension reminded me that no has expressed an opinion on this one.

Thoughts?

David J.

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

Предыдущее
От: Sandeep Thakkar
Дата:
Сообщение: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore