Re: Newbie questions, diff between functions and procedures; & why cube functions? - Mailing list pgadmin-support

From Raymond O'Donnell
Subject Re: Newbie questions, diff between functions and procedures; & why cube functions?
Date
Msg-id 45660317.9164.C8E89@rod.iol.ie
Whole thread Raw
In response to Newbie questions, diff between functions and procedures; & why cube functions?  (novnov <novnovice@gmail.com>)
Responses Re: Newbie questions, diff between functions and
Re: Newbie questions, diff between functions and
List pgadmin-support
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
----------------------------------------------------------------------




pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Report stylesheet bug
Next
From: Christian Eva
Date:
Subject: Re: Re: [pgadmin-support] Compile Error with 1.6+ on SuSE 10.0/10.1 :xmlerror.h:820: error: typedef‘xmlGenericErrorFunc’ is initialized (use__typeof__ instead)