Re: search_path vs extensions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: search_path vs extensions
Дата
Msg-id 25641.1243630172@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: search_path vs extensions  (Greg Stark <stark@enterprisedb.com>)
Ответы Re: search_path vs extensions  (Andrew Dunstan <andrew@dunslane.net>)
Re: search_path vs extensions  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Greg Stark <stark@enterprisedb.com> writes:
> I'm actually not sure if we should allow extensions to be installed
> into separate schemas.

It's starting to seem that best practice is to install "public"
functions/etc into a common schema and "private" objects into an
extension-specific schema.  The main problem with that from an extension
author's point of view is the need to explicitly qualify all references
to private objects, since they won't be in the search path.  Which is
tedious, but doable.

Another issue is that doing that pretty much hard-wires what the
extension's private schema name is.  Dunno how much we care, though.

You could certainly do this without any new search-path-related
features, but I wonder whether the system could provide any extra
support for it.
        regards, tom lane


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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Clean shutdown and warm standby
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: search_path vs extensions