Multiple Schema and extensions

Поиск
Список
Период
Сортировка
От Alan Nilsson
Тема Multiple Schema and extensions
Дата
Msg-id EFCC5DA0-F2E6-48B4-8727-3154A3F1A007@apple.com
обсуждение исходный текст
Ответы Re: Multiple Schema and extensions  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
Is it the case that extensions can be added to only one schema?  If so, what is the recommended practice for accessing
afunction from an extension in multiple schemas? 

Is it *ok* to load the extension in the pg_catalog schema so functions can be accessed by unqualified names?  Is it
*better*to have a separate schema for functions and use qualified names to access?  What is the general accepted
practice?

As a side note:
ALTER EXTENSION foo ADD SCHEMA bar
What the heck does this do?  AFICS, it has no effect on the visibility of an extension function in the *added* schema.

thanks
alan



В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: In one of negative test row-level trigger results into loop
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: In one of negative test row-level trigger results into loop