Обсуждение: Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y

> 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.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

>
> > 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. -

> >
> > > 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.

Good point.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

> > > 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.

Really? Neat. Okay, its descriptive. Did I miss this in the docs or forget
it? I think this should be mentioned at an appropriate place in the
beginning of the docs. Such as when discussing how to create a database.


Bruce Tong                 |  Got me an office; I'm there late at night.
Systems Programmer         |  Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE  |
zztong@laxmi.ev.net        |  -- Joe Walsh for the 21st Century