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