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