Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore
Date
Msg-id CAKFQuwYbqurFWg0W8mqBsHLsCyxZAZqBdV0q-beEFTbeBNhO2A@mail.gmail.com
Whole thread Raw
In response to Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore
List pgsql-bugs
Tree view
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 by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: Re: edb installation failed for pgadmin when username is Chinese under c;\user #7432
Next
From: Tom Lane
Date:
Subject: Re: Upgrading an extension's extnamespace from user-specified to a defined schema breaks dump/restore