Re: Proposal: allow installation of any contrib module - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Proposal: allow installation of any contrib module
Date
Msg-id 45B8FD7C.4030703@dunslane.net
Whole thread Raw
In response to Re: Proposal: allow installation of any contrib module  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Joshua D. Drake wrote:
> Teodor Sigaev wrote:
>   
>>> This might be a good idea, but it's hardly transparent; it can be
>>> counted on to break the applications of just about everyone using those
>>> modules today.
>>>       
>> Hmm, can we make separate schema for all contib modules and include it
>> in default search_path? It will not touchs most users.
>>     
>
> Oh now that is interesting... something like a contrib schema that
> everything is loaded into? That would would work nicely and removes a
> lot of problems.
>
> People can use the modules if they want, they don't have to enable the
> functions but they aren't in the way of their app or db either.
>
>
>   
I think I'd rather have one schema per module than one for all of 
contrib, but maybe the addition to the search path makes a single schema 
more sensible.

Another approach to backwards compatibility issue, perhaps, would have 2 
install scripts per module, one that installs stuff in the public schema 
for legacy purposes, and one that uses a dedicated schema.

cheers

andrew



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Proposal: allow installation of any contrib module
Next
From: "Simon Riggs"
Date:
Subject: Implied Functional index use (redux)