Re: citext, actually probably using extensions - Mailing list pgsql-general

From Morris de Oryx
Subject Re: citext, actually probably using extensions
Date
Msg-id CAKqncciYFoZLQBN7Evgw+Sm_V2_SJjeUe6PAGnosoPywSSdubA@mail.gmail.com
Whole thread Raw
In response to Re: citext, actually probably using extensions  (Rob Sargent <robjsargent@gmail.com>)
Responses RE: citext, actually probably using extensions
List 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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: citext, actually probably using extensions
Next
From: Thiemo Kellner
Date:
Subject: Use of ?get diagnostics'?