Re: Schema's, roles and privileges

In article <200911300708.12397.aklaver@comcast.net>,
Adrian Klaver  writes:

> From a quick look it would seem the easiest solution would be to change the 
> search_path in:
> citext.sql.in 
> uuid-ossp.sql.in
> These files are found in the respective contrib directories. Uninstall the 
> modules. Rerun make and then reinstall.

FWIW:

I also manage some databases needing one or more contrib/pgfoundry
modules.  By habit, I install each module in its own schema (with read
access to everybody and write access to nobody) - this helps to
distinguish between your own DDL and the DDL of helper modules.  For
example:
 CREATE SCHEMA prefix; SET search_path = mymodule; \i path_to/mymodule.sql ALTER DATABASE mydb SET search_path = public, mymodule;

The SQL files of a few modules mess with the search_path themselves;
this can be fixed by editing a copy of .sql and \inserting the
copy.