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#a7542987
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
