Re: Newbie questions, diff between functions and procedures; & why cube functions?

["Raymond O'Donnell" <rod(at)iol(dot)ie>]

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(at)iol(dot)ie
----------------------------------------------------------------------