OK, thanks...and I take it that there is nothing about the cube functions
that are inherently needed? I've never touched template1, this is an out of
the box postgres 8.1 windows install.
Raymond O wrote:
>
> 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
> ----------------------------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
>
--
View this message in context:
http://www.nabble.com/Newbie-questions%2C-diff-between-functions-and-procedures----why-cube-functions--tf2689810.html#a7535268
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.