On 25 Nov 2006 at 14:24, novnov wrote: > In all of postgres 8.1.4 (windows) databases I create there are a > bunch of cube and g_cube functions added to the db. If these are not > needed, is there a simple way to make sure that they are not added to > new databases? As I was telling you on the pgadmin-support list, these are copied from the template1 database whenever you create a new database - the CREATE DATABASE command effectively duplicates template1. To prevent these functions from appearing in your new databases, remove them from template1. Have a look at the docs: http://www.postgresql.org/docs/8.1/interactive/manage-ag- createdb.html --Ray O'Donnell ---------------------------------------------------------------------- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland rod@xxxxxx ----------------------------------------------------------------------
