Thanks for haning in there with me on this. I know the contrib modules stuff
is pgsql, not pgAdmin, but pgAdmin could probably be extended to allow for
simpler access to the template1 db. I'd guess that it could be loaded just
like any db and altered, though of course should only be exposed by special
request in a pgAdmin menu.
I've not actually reinstalled pgsql (8.1). What I did is to review the
screenshots I took of my installation process, and there wasn't any step (at
least that I captured) for contrib modules. Also, in the windows add/remove
one can reenter the pgsql setup process, which is a cool feature (not all
windows programs offer that reentry point). There is no contrib module
config area there either. It's possible that both my screenshots and the
add/remove programs thing skip the contrib module config section...but as
far as I can tell there is nothing to adjust. I hesitated to remove and then
reinstall pgsql because I thought it might intro some other odd variable
into my pgsql issues...but I will if somehow that does allow access to the
contrib modules that are loaded. I'll test on another pc.
Raymond O wrote:
>
> On 28 Nov 2006 at 9:42, novnov wrote:
>
>> I will resort to ininstalling pgsql and reinstalling. I have to say
>> that this aspect of pgsql is rather difficult to work with. Starting
>> with why cube and g_cube modules are included by default and ending
>> with the difficulty of manipulating template1...it could be easier for
>> newbies.
>
> Are you using the Windows installer? If so, when you come to the
> screen that asks you what modules you want included by default, make
> sure that none of the check boxes are checked. If you need a specific
> module, you can always add it afterwards by running the necessary sql
> script.
>
> What version of PostgreSQL are you using?
>
>> Would it be possible in a future release of pgAdmin that access to
>> these settings can be adjusted?
>
> The contrib modules are a PostgreSQL feature, not pgAdmin.
>
> --Ray.
>
>
> ----------------------------------------------------------------------
>
> Raymond O'Donnell
> Director of Music, Galway Cathedral, Galway, Ireland
> rod@iol.ie
> ----------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
--
View this message in context:
http://www.nabble.com/Newbie-questions%2C-diff-between-functions-and-procedures----why-cube-functions--tf2689810.html#a7584758
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.