Re: Contrib Schemas
Josh Berkus <josh@agliodbs.com>
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
David Fetter <david@fetter.org>
Date: 2006-01-13T01:11:39Z
Lists: 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