Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y - Mailing list pgsql-hackers

From dg@illustra.com (David Gould)
Subject Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
Date
Msg-id 9807241909.AA27939@hawk.illustra.com
Whole thread Raw
In response to Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
List pgsql-hackers
>
> > Okay, I've suspected there was more to "template1" for a little while now,
> > but I'd not gotten around to looking into it more. Still, my first
> > impression was it was a sample database. ;) Maybe a name like "master"
> > would be clearer, or maybe that means something else to someone.
> >
>
> Yes, master would be a better name than template1.


I disagree. template1 is not only the "master" database, it is also used as
as the template when creating a new database. That is, if you want to create
all your databases with certain characteristics (say installed functions or
types or something) you can set up template1 the way you want, dump it to
the template dump file and then any new db will be created with your
customization. So template1 really is a discriptive term.

-dg


David Gould            dg@illustra.com           510.628.3783 or 510.305.9468
Informix Software  (No, really)         300 Lakeside Drive  Oakland, CA 94612
 - If simplicity worked, the world would be overrun with insects. -

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Query plan affected by lack of explicit cast?
Next
From: Bruce Momjian
Date:
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y