Re: Extensions not dumped when --schema is used

From: Asif Rehman <asifr(dot)rehman(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Subject: Re: Extensions not dumped when --schema is used
Date: 2021-02-03 17:32:19
Message-ID: 161237353962.16840.7166786393737397675.pgcf@coridan.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The following review has been posted through the commitfest application:
make installcheck-world: tested, passed
Implements feature: tested, passed
Spec compliant: not tested
Documentation: not tested

The patch applies cleanly and looks fine to me. However consider this scenario.

- CREATE SCHEMA foo;
- CREATE EXTENSION file_fdw WITH SCHEMA foo;
- pg_dump --file=/tmp/test.sql --exclude-schema=foo postgres

This will still include the extension 'file_fdw' in the backup script. Shouldn't it be excluded as well?

The new status of this patch is: Waiting on Author

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2021-02-03 17:42:11 Re: Extensions not dumped when --schema is used
Previous Message Heikki Linnakangas 2021-02-03 16:47:05 Re: Removing support for COPY FROM STDIN in protocol version 2