Re: citext, actually probably using extensions

Поиск
Список
Период
Сортировка
От Morris de Oryx
Тема Re: citext, actually probably using extensions
Дата
Msg-id CAKqncciYFoZLQBN7Evgw+Sm_V2_SJjeUe6PAGnosoPywSSdubA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: citext, actually probably using extensions  (Rob Sargent <robjsargent@gmail.com>)
Ответы RE: citext, actually probably using extensions
Список pgsql-general
Not sure about best practices, but what I'm going is like this:

* Create a schema named extensions.

* Install extensions in this special schema only. I don't put anything else in there.

* Put the extensions schema early (left) in the search_path for each role.

* Grant execute access permissively on the functions in that schema.

If there's something deeply flawed about this strategy, I'd be keen to hear about it. On the positive side, I find it simple to understand, maintain, and explain to other people. YMMV

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: citext, actually probably using extensions
Следующее
От: Thiemo Kellner
Дата:
Сообщение: Use of ?get diagnostics'?