Skip site navigation (1) Skip section navigation (2)

Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y

From: dg(at)illustra(dot)com (David Gould)
To: maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian)
Cc: zztong(at)laxmi(dot)ev(dot)net, hackers(at)postgreSQL(dot)org, docs(at)postgreSQL(dot)org
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
Date: 1998-07-24 19:09:12
Message-ID: 9807241909.AA27939@hawk.illustra.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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(at)illustra(dot)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. -

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-07-24 19:13:47
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
Previous:From: Tom LaneDate: 1998-07-24 19:00:11
Subject: Query plan affected by lack of explicit cast?

pgsql-general by date

Next:From: Bruce MomjianDate: 1998-07-24 19:13:47
Subject: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y
Previous:From: Steve DoliovDate: 1998-07-24 18:41:43
Subject: Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group