On Tuesday, June 21, 2022, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 17526
Logged by: chris
Email address: developer@moregatebiotech.com
PostgreSQL version: 14.4
Operating system: Linux
Description:
PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is
assigned to a schema.
Not a bug. Extension members are not dumped because the system expects that a subsequent create extension command will create them. That is what it means to be a member of the extension. Most users are not going to execute the “alter extension add” command on there database as it doesn’t really provide end-user useful functionality.
Extension assigned to a schema is not the correct model here. “Given control of the schema” or “Schema becomes an implementation detail of the extension” are.
I’ve been working on the docs in this area but focused on routines. I will give this a look to see if additional clarity here is needed too.
David J.