Re: Contrib Schemas

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Contrib Schemas
Дата
Msg-id 200601121711.40132.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Contrib Schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Contrib Schemas
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Contrib Schemas