Re: BUG #16698: Create extension and search path

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16698: Create extension and search path
Дата
Msg-id 918521.1604414169@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #16698: Create extension and search path  (Miha Vrhovnik <miha.vrhovnik@gmail.com>)
Ответы Re: BUG #16698: Create extension and search path  (Miha Vrhovnik <miha.vrhovnik@gmail.com>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: BUG #16698: Create extension and search path
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg should ignore u+200b zero width space