Re: template0 database comment

On Sat, Mar 12, 2011 at 8:59 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Dave Page wrote:
>> On 3/12/11, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> > Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> >> People are confused about what template0 is for, so I created the
>> >> attached one-line patch to add a database comment to template0. No
>> >> initdb, I assume, becuase it is just a comment.
>> >
>> >> +          "COMMENT ON DATABASE template0 IS 'only used by pg_dump';\n",
>> >
>> > No objection to the concept, but the actual text of this comment is
>> > approximately 100% wrong.
>> >
>>
>> I'd like to lodge a formal objection to the use of the word
>> 'approximately' in the above comment.
>
> OK, funny guys.  ;-)  Can someone give me the right text.  Obviously I
> don' know what template0 is used for either.  Is it pg_dumpall perhaps?

Whaa?!?!

pg_dump has nothing to do with it. Only used by createdb

Possibilities include:
- 'base template database'
- 'base template (used if template1 is corrupted)'
- 'backup template (use if template1 corrupted)'

Contrast with template1
- 'default template for creation of new databases'

I dunno that those are the *best* wordings, but they may suggest one.
--
http://linuxfinances.info/info/linuxdistributions.html