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.

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