Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16698: Create extension and search path - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16698: Create extension and search path
Date
Msg-id 918521.1604414169@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16698: Create extension and search path  (Miha Vrhovnik <miha.vrhovnik@gmail.com>)
Responses Re: BUG #16698: Create extension and search path
List pgsql-bugs
Tree view 
Miha Vrhovnik <miha.vrhovnik@gmail.com> writes:
> I'm so sorry, but I do not understand... Even if I force the schema in
> CREATE EXTENSION it still says that it already exists. (Tested on 12.4, but
> it's the same with 13, as I have tested it before)
> I'm missing something but the documentation doesn't state that I can only
> install extension once per database.

Extensions are not schema-qualified objects, so no, you cannot have
more than one instance per database.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: BUG #16698: Create extension and search path
Next
From: Tom Lane
Date:
Subject: Re: pg should ignore u+200b zero width space