From: Michael Gould <mgould@intermodalsoftwaresolutions.net>
To: pgsql-sql@postgresql.org
Subject: placement of stored procedures and contrib modules
Date: Mon, 1 Mar 2010 07:25:30 -0600
Message-ID: <0ca62990c481026fb0a013b7a7ff13d3@intermodalsoftwaresolutions.net> (raw)
In-Reply-To: <27741669.post@talk.nabble.com>
We were trying to use a separate schema to put contrib modules, stored
procedures and triggers from our database schema. We called the one where
we stored all of the modules isscontrib and the other iss which is where the
db is stored. We've fully qualified the names of our items from isscontrib
and have also included that schema in the search path.
Our goal is to eventually mark isscontrib as execute only. Is there any
restrictions to having objects in a separate schema? We are using the
citext contrib module. It doesn't appear to work when it's in the isscontrib
module. We don't get any error messages however we also don't get the
results we are looking for, namely case insensitive search results.
However, if we move the contrib module to the public schema, everything
appears to work fine.
Best Regards
Mike Gould
--
Michael Gould, Managing Partner
Intermodal Software Solutions, LLC
904.226.0978
904.592.5250 fax
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: mgould@intermodalsoftwaresolutions.net
Subject: Re: placement of stored procedures and contrib modules
In-Reply-To: <0ca62990c481026fb0a013b7a7ff13d3@intermodalsoftwaresolutions.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