RE: citext, actually probably using extensions

From: Kevin Brannen <KBrannen(at)efji(dot)com>
To: Morris de Oryx <morrisdeoryx(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: RE: citext, actually probably using extensions
Date: 2019-09-23 19:11:01
Message-ID: DM6PR19MB34512C8282CD3F9ABDF14D63A4850@DM6PR19MB3451.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> From: Morris de Oryx <morrisdeoryx(at)gmail(dot)com>
>
> 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
>

We do approximately the same thing if it makes you feel better, although we call our schema "common".
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-09-23 19:37:23 Re: can't install pg 12 beta on centos 6
Previous Message Tom Lane 2019-09-23 19:06:38 Re: Error during analyze after upgrade from 10.10 -> 11.4