Re: Dependency isn't created between extension and schema - Mailing list pgsql-hackers

On Mon, Dec 21, 2020 at 04:02:29PM +0900, Masahiko Sawada wrote:
> Is it a bug? Since the created schema obviously depends on the
> extension when we created the schema specified in the schema option, I
> think we might want to create the dependency so that DROP EXTENSION
> drops the schema as well. I’ve attached the draft patch so that CREATE
> EXTENSION creates the dependency if it newly creates the schema.

FWIW, I recall that the "soft" behavior that exists now is wanted, as
it is more flexible for DROP EXTENSION: what you are suggesting here
has the disadvantage to make DROP EXTENSION fail if any non-extension
object has been created on this schema, so this could be disruptive
when it comes to some upgrade scenarios.

      <term><replaceable class="parameter">schema_name</replaceable></term>
       <listitem>
    <para>
     The name of the schema in which to install the extension's
         objects, given that the extension allows its contents to be
         relocated.  The named schema must already exist.
While on it..  The docs are incorrect here.  As you say,
CreateExtensionInternal() may internally create a schema.
--
Michael