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@xxxxxx > ---------------------------------------------------------------------- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx 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.
