Re: Newbie questions, diff between functions and

OK, thanks...and I take it that there is nothing about the cube functions
that are inherently needed? I've never touched template1, this is an out of
the box postgres 8.1 windows install.


Raymond O wrote:
> 
> On 22 Nov 2006 at 17:21, novnov wrote:
> 
>> Not sure this is a pgAdmin question either but why does pg seem to
>> create a mass of cube and g_cube functions for each new db? They sure
>> clutter up the place, but maybe they are needed by postgres? 
> 
> It soundsas if one of the contrib modules may be loaded by default - 
> new DBs are created by copying the template1 database, so anything 
> that's in template1 is included in new databases also.
> 
> There is a procedure, if you don't want this or if you load a heap of 
> stuff into template1 by accident, for zapping template1 and re-
> creating it in turn from template0 - it's detailed at 
> http://www.postgresql.org/docs/techdocs.22
> 
> --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#a7535268
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.