Re: Contrib Schemas - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Contrib Schemas
Date
Msg-id 200601121711.40132.josh@agliodbs.com
Whole thread Raw
In response to Re: Contrib Schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

> People who want the contrib stuff segregated can easily make it
> happen by modifying the contrib .sql files before they run them.
> The .sql files already have a skeleton for this, eg
>     -- Adjust this setting to control where the objects get created.
>     SET search_path = public;
> I don't really see a need to go further than that.

Tangentally, I filed a but with Tsearch2 because that SET statement is 
outside the transaction in the .sql file, which means that stuff will end 
up in the public schema if the admin typos the schema name.  Not sure if 
other contrib modules have the same issue.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Contrib Schemas
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Contrib Schemas