Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > For example, one could drop <literal>template1</> and recreate it from
> > <literal>template0</> without any ill effects. This course of action
> > might be advisable if one has carelessly added a bunch of junk in
> > ! <literal>template1</>. (To delete <literal>template1</literal>,
> > ! it must have <literal>datistemplate = false</>.)
> > </para>
>
> I don't find this particularly clear -- how does the user know where to
> set the "datistemplate" it refers to? I guess you should mention
> pg_database, or be more explicit about what to do.
OK, it is now:
<literal>template1</>. (To delete <literal>template1</literal>,
it must have <literal>pg_database.datistemplate = false</>.)
--
Bruce Momjian [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
