Isn't there an option when you install on windows that controls what
contrib stuff is included?
Anyway, it's pretty simple to add plpgsql back in using CREATE LANGUAGE.
On Nov 25, 2006, at 5:16 PM, novnov wrote:
I hadn't checked and the page you pointed to here was different
from the one
you pointed to on the other list
(http://www.postgresql.org/docs/techdocs.22). I've experimented a
bit and
have been able to see what template0 consists of by creating a db
based on
it. It lacks the ref to the lang plpgsql. So if I made a new
template1 from
template0, all new dbs would lack that lang. That leaves me with a
different
starting point for my new dbs but still not what I want.
Seems like this core config aspect of postgres could be a little
simpler to
manage...anyways I'll figure it out, your pointers have helped.
novnov wrote:
Hi Ray - yes I read and checked in to your advice on the other
list but I
posted here because the procedure looked a little complex and
possibly
risky for a newbie like me. Rather than ask you for a simpler way
to go, I
figured I'd post here and see what I came up with...and knew of
course
that you'd probably be on this list too. I'm just hoping that
there is a
way to clear those spurious (to me) entries without the level of
hacking
that the article you pointed me to entailed.
Raymond O wrote:
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
--------------------------------------------------------------------
--
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so
that your
message can get through to the mailing list cleanly
--
View this message in context: http://www.nabble.com/Editing-contrib-
modules-which-are-loaded-by-default--tf2705139.html#a7543210
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that
your
message can get through to the mailing list cleanly
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
