I hadn't checked and the page you pointed to here was different from the one
you pointed to on the other list
(http://www.postgresql.org/docs/techdocs.22). I've experimented a bit and
have been able to see what template0 consists of by creating a db based on
it. It lacks the ref to the lang plpgsql. So if I made a new template1 from
template0, all new dbs would lack that lang. That leaves me with a different
starting point for my new dbs but still not what I want.
Seems like this core config aspect of postgres could be a little simpler to
manage...anyways I'll figure it out, your pointers have helped.
novnov wrote:
>
> Hi Ray - yes I read and checked in to your advice on the other list but I
> posted here because the procedure looked a little complex and possibly
> risky for a newbie like me. Rather than ask you for a simpler way to go, I
> figured I'd post here and see what I came up with...and knew of course
> that you'd probably be on this list too. I'm just hoping that there is a
> way to clear those spurious (to me) entries without the level of hacking
> that the article you pointed me to entailed.
>
>
>
> Raymond O wrote:
>>
>> On 25 Nov 2006 at 14:24, novnov wrote:
>>
>>> In all of postgres 8.1.4 (windows) databases I create there are a
>>> bunch of cube and g_cube functions added to the db. If these are not
>>> needed, is there a simple way to make sure that they are not added to
>>> new databases?
>>
>> As I was telling you on the pgadmin-support list, these are copied
>> from the template1 database whenever you create a new database - the
>> CREATE DATABASE command effectively duplicates template1.
>>
>> To prevent these functions from appearing in your new databases,
>> remove them from template1.
>>
>> Have a look at the docs:
>> http://www.postgresql.org/docs/8.1/interactive/manage-ag-
>> createdb.html
>>
>> --Ray O'Donnell
>>
>> ----------------------------------------------------------------------
>>
>> Raymond O'Donnell
>> Director of Music, Galway Cathedral, Galway, Ireland
>> rod@iol.ie
>> ----------------------------------------------------------------------
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: if posting/reading through Usenet, please send an appropriate
>> subscribe-nomail command to majordomo@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Editing-contrib-modules-which-are-loaded-by-default--tf2705139.html#a7543210
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
