Re: Editing contrib modules which are loaded by default? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Editing contrib modules which are loaded by default?
Date
Msg-id 4568C532.32219.F23F51@rod.iol.ie
Whole thread Raw
In response to Editing contrib modules which are loaded by default?  (novnov <novnovice@gmail.com>)
Responses Re: Editing contrib modules which are loaded by default?  (novnov <novnovice@gmail.com>)
List pgsql-general
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@iol.ie
----------------------------------------------------------------------



pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: which version? old user coming back....
Next
From: novnov
Date:
Subject: Re: Editing contrib modules which are loaded by default?