which schema to install contrib modules

From: Paul Silveira <plabrh1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: which schema to install contrib modules
Date: 2006-12-22 14:53:40
Message-ID: 8024340.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I was wonding what the community's opinion was on which schema the contrib
modules should be installed into. I intend on using DBLink, tsearch2, and
xml2 and have initially installed them in the public schema. That will work
but it really clutters that schema and I was also intending on using that
for my application as well. Is there any value to creating a "contrib"
schema and installing them there and then just referencing them via the
contrib.<FUNCTION> convention? I was also thinking that I could just change
my postgresql.conf file to have my schema order read $user, public, contrib.

Is it more valuable to just move my application into it's own schema and
leaving the contribs in the public schema?

Thoughts?

Paul
--
View this message in context: http://www.nabble.com/which-schema-to-install-contrib-modules-tf2870947.html#a8024340
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Browse pgsql-general by date

  From Date Subject
Next Message Paul Silveira 2006-12-22 16:07:26 Re: xml2 install problem
Previous Message Tim Tassonis 2006-12-22 14:52:34 Re: Tricky join question