pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Harald Fuchs <hari.fuchs@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Schema's, roles and privileges
Date: Mon, 30 Nov 2009 18:51:39 +0100
Message-ID: <pumy23ew9g.fsf@srv.protecting.net> (raw)
References: <803af4645647a59bcb56badac2b1cd8f@intermodalsoftwaresolutions.net>
	<200911300708.12397.aklaver@comcast.net>

In article <200911300708.12397.aklaver@comcast.net>,
Adrian Klaver <aklaver@comcast.net> 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 <module>.sql and \inserting the
copy.




view thread (4+ messages)

Message-ID: <pumy23ew9g.fsf@srv.protecting.net>
Permalink:  ../pumy23ew9g.fsf@srv.protecting.net/
Also on:    postgresql.org/message-id/pumy23ew9g.fsf@srv.protecting.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: hari.fuchs@gmail.com
  Subject: Re: Schema's, roles and privileges
  In-Reply-To: <pumy23ew9g.fsf@srv.protecting.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox