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 [EMAIL PROTECTED] ---------------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
