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

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
----------------------------------------------------------------------